Skip to main content
Question

Opening Master Detail Records in New Window

  • March 28, 2017
  • 0 replies
  • 55 views

I have established a master to detail routine where I am using a template to add records to a child table en masse.  It works well.  But is there a possibility that I could open the newly created records in a new window? And once these are saved,  I could see these records by pushing a button on the parent record? I understand I will use two buttons and hide these as appropriate.  I am using following statement to import records.

"javascript:void(copyMasterDetailButtonHandler('&relfids=133&sourceRID=4068&destrid=" & [Record ID#] & "', 'bksybcgkb'))"
 
This topic has been closed for replies.

  • Registered
  • March 28, 2017
To answer part of your question (I could see these records by pushing a button on the parent record):

You can create either a formula-url or formula text field.  And structure a query to search for the records associated with that parent.

Formula-Text example:


href=' "&URLRoot() & "db/" & [_DBID_MyChildTable] & "?a=q&query={33.EX."&[Record ID#]&"}' target='_blank'

Where field id "33" is your [Related Parent] field.
Using target='_blank' will open the search in a new window/tab.

  • Author
  • Registered
  • March 28, 2017
Thanks Matt. Are you missing a parentheses somewhere?

  • Registered
  • March 28, 2017
Yes, Sorry,  I only put part of the equation to show you the idea.

Here is a more complete option.


"<a class='Vibrant Success' href=' "&URLRoot() & "db/" & [_DBID_MyChildTable] & "?a=q&query={33.EX."&[Record ID#]&"}' target='_blank'>Search Records</a>"

(Formula Text Field with HTML enabled)

  • Author
  • Registered
  • March 28, 2017
Thanks. Tried it but there is an error.

This site can�t be reached

%3Ca%20class%3D%27vibrant%20success%27%20href%3D%27%20https�s server DNS address could not be found.
Search Google for class 'vibrant success' href https ww quickbase bmni94hr5

  • Registered
  • March 30, 2017
Did you change out all the appropriate variables?
the DBID, the 33 for your field doing the search, and the query item (record ID#)?

Formula text field correct?

  • Author
  • Registered
  • March 30, 2017
Thanks. I had URL field. When I changed this to text, it worked. Appreciate.