Link to record in connected table
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!
Forum Discussion
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.
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.