Forum Discussion

EvanFujikawa's avatar
EvanFujikawa
Qrew Cadet
7 years ago

Is there a way to return from child table back to the parent parent record?

When I'm in the child record table is there a way to return back to the specified parent record? When I select the related record ID it take me to a form with partial information and is different from the parent record form.

4 Replies

  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    It sounds like you might have multiple forms for the parent record.  Is that the case?

    If so, you will need to create a formula url that specifies the form that you want to go to.  
    That can be done with a 

    &dfid=10

    display_form_id
  • I have multiple parent forms leading to the same child record table. Would the url formula be placed in the parent or child form?
  • There are two ways you can handle the returning to the correct parent form. One is encoding the correct dfid in the URL like Matthew suggested. It would be a formula url like : 
    URLRoot() & "db/ABC123456?a=er&dfid=12_fid_9=" & URLEncode ([Related Parent Record ID#]]) 

    ABC123456 = parent table dbid

    This formula will only take you to the specific form (form id 12). You can use some logic to dynamically change the form id it goes back to or use multiple buttons which take you to the different forms. This formula field will be in the child table

    second way is - to encode "&z=" & Rurl() at the end of your add child record formula URL in the parent table.

    the z=rurl() will return to the prior page (be it a form or a report). That means once the user is done adding the child record he/she will return to the original form/page they started with.

    An example would be URLRoot() & "db/DEF123456?a=API_GenAddRecordForm&_fid_9=" & URLEncode ([Parent Record ID#])& "&z=" & Rurl()

    the DEF123456 = child table dbid.
  • There are two ways you can handle the returning to the correct parent form. One is encoding the correct dfid in the URL like Matthew suggested. It would be a formula url like : 
    URLRoot() & "db/ABC123456?a=er&dfid=12_fid_9=" & URLEncode ([Related Parent Record ID#]]) 

    ABC123456 = parent table dbid

    This formula will only take you to the specific form (form id 12). You can use some logic to dynamically change the form id it goes back to or use multiple buttons which take you to the different forms. This formula field will be in the child table

    second way is - to encode "&z=" & Rurl() at the end of your add child record formula URL in the parent table.

    the z=rurl() will return to the prior page (be it a form or a report). That means once the user is done adding the child record he/she will return to the original form/page they started with.

    An example would be URLRoot() & "db/DEF123456?a=API_GenAddRecordForm&_fid_9=" & URLEncode ([Parent Record ID#])& "&z=" & Rurl()

    the DEF123456 = child table dbid.