Button to go to parent record in a different application
Is there a way to add a button in the child record that will take you to the parent record (in a different app) instead of the parent record showing as a link?
Forum Discussion
- Hi TRNC,
Does the Child Record contain a field that matches with the key field from the Parent Record in the other app? - Excuse my ignorance on this question. Would that be the 'Related PO' that links back to the parent record?
- Hi TRNC,
Yes most likely if the Parent table is a PO table then the Related PO table would most likely be the matching field between the two tables. If so you can use a Formula URL button set to use that Related PO field to display the Parent Record when the button is pushed. It would use a formula url field with a formula like:
URLRoot() & "db/" & "DBID Here" & "?a=dr&key="&[Related PO]
What you would need to input here is the DBID of the Parent table in the formula where it says DBID Here. The DBID can be found by going to the table you are wanting to display and in the URL in the address bar it is the chain of numbers and letters that appear after /db/ and before ?a=. That essentially lets the button know which table you are trying to open up and then asking it to display the record from that PO table that has the same Related PO as its Record ID#.
