Discussions

Expand all | Collapse all

Button to go to parent record in a different application

  • 1.  Button to go to parent record in a different application

    Posted 02-08-2018 15:24
    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?


  • 2.  RE: Button to go to parent record in a different application

    Posted 02-08-2018 15:57
    Hi TRNC,

    Does the Child Record contain a field that matches with the key field from the Parent Record in the other app?


  • 3.  RE: Button to go to parent record in a different application

    Posted 02-08-2018 16:28
    Excuse my ignorance on this question. Would that be the 'Related PO' that links back to the parent record?


  • 4.  RE: Button to go to parent record in a different application

    Posted 02-08-2018 18:24
    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#.