Forum Discussion

DavidSemitekol's avatar
DavidSemitekol
Qrew Trainee
3 years ago

Formula button to view record from another table

I have a related table.  I want to modify the "add record" to only view the child record.  Basically I want to recreate the "View Record" eyeball icon that is found in the report table.  (I don't want...
  • MarkShnier__You's avatar
    3 years ago
    I gather you want this button to live on the Parent Table.  But One Parent can have many children so it's not  clear which Child record you want to view. Perhaps your design is such that there is only one child record.  If that is the case, then go to the relationship and add a summary field to get the Summary Minimum of the [Record ID#] field.  Perhaps name the field [Record ID# of 1st Child]

    Then you would adjust your formula like this

    URLRoot() & "db/" & [_DBID_TEST] & "?a=dr&rid=" & [Record ID# of 1st Child]



    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------