Discussions

Expand all | Collapse all

Returning to parent table from child to grandchild relationship

  • 1.  Returning to parent table from child to grandchild relationship

    Top
    Contributor
    Posted 07-19-2017 18:33
    This sounds crazy from the title, but what I currently am doing is creating a project in a parent table.  From this table I go into the child table to enter required data.  But in one particular relationship I have there is a child table that I input data into and from there I go into a grandchild table to add some data also.  This is where the problem occurs.

    When I save the record in the child table I return correctly to the parent table to continue entering data on the project.  But when I go from the child table to the grandchild, the link breaks that forces a save and return to the parent.  At this point I have to go back to the parent table and edit the record.

    Any thoughts?


  • 2.  RE: Returning to parent table from child to grandchild relationship

    Posted 07-19-2017 18:46
    I'm not quite understanding.

    You are on a Project and Add Child and presumably the Project table is set to save automatically.

    Now you Add Child and then Add Grandchild and the Child Saves automatically.  Is your issue what happens at that point.


  • 3.  RE: Returning to parent table from child to grandchild relationship

    Top
    Contributor
    Posted 07-19-2017 19:13
    I found your posting earlier about setting tables to save parent record when child record is created and I have implemented this on all tables.  So you are correct in that when I am on the parent (Project) table and create the child record (Information), the project saves automatically.  Upon completing the data entry in the Information table and saving the record, I am automatically returned to the Project table to continue entering all pertinent information.

    The problem arises when I choose to create a record in a child table (Feeders) and from within this table I go into a grandchild table (Regulators) to enter data there.  So when I select to enter the Regulator table to enter data, the Feeder table saves and then the Regulator table opens to enter data there.  Upon saving the Regulator record(s), I enter back into the Feeder table.  I hit save but I just stay in the Feeder table now.  

    I believe at this point in the process I have broken the Save and Resume functionality which is keeping me from returning back the the Project table to finish entering the project.


  • 4.  RE: Returning to parent table from child to grandchild relationship

    Posted 07-19-2017 22:49
    So it seems to be be working properly lands you back on the Parent record of the one you just saved, which in your case it actually the child record of the main Parent project.  

    There are two choices

    1. Just have a link on the feeder record and the user will then navigate back to the parent. But i guess that you don't link that option.

    The other options that should work is to make a formula field like this to Add Regulator.

    var text ADDRegulator = ( and then paste in here the same formula that you have now but without the last last which is like & & "&z=" & Rurl() (be sure to end with a semicolon ;

    var text DisplayProject = urlroot() & "db/" & [_DBID_PROJECTS] & "?a=dr&rid=" & [Related Project];

    $ADDRegular
    & "&NextURL=" & URLEncode($DisplayProject)


  • 5.  RE: Returning to parent table from child to grandchild relationship

    Top
    Contributor
    Posted 08-02-2017 13:13
    Thanks for the reply.  Ended up getting smart and changing the relationship to make more sense.  Back to my motto "Work Smarter, Not Harder"!