Discussions

Expand all | Collapse all

Link to record in connected table

  • 1.  Link to record in connected table

    Posted 11-19-2018 17:14
    I've connected two tables from two apps and would like to have a link to the record in the source table available in the record in the connected table. Similar to a link to a parent record.

    Thanks!


  • 2.  RE: Link to record in connected table

    Posted 11-19-2018 19:19
    You can make a formula URL button to go to from Sync back to the Parent.

    urlroot()  & "db/" & "xxxxxx" & "?a=dr&rid=" & [Record ID#2]


    The xxxxx will need to be the table code that you see when you view a record in the original table.  It will be the part after the db/ 
    and will be about 7 characters long.

    The Record ID to display will be whatever the field is called which is the Refresh Key on your Sync table.  If you did not rename it, it is likely still called [Record ID#2].  You can rename that to be called what it is, which is [Record ID# of original source table record].

    To get back to view the sync table record from the original table, try this

    urlroot()  & "db/" & "yyyyyyy" & "?a=dr&key=" & [Record ID#]

    where yyyyyy is the table ID code in the sync table.