Forum Discussion

EleonoraRuffin1's avatar
EleonoraRuffin1
Qrew Member
3 years ago

Child table form based on parent's field value

Hi,
I have a report link on a parent table. When the user clicks on a specific record of the report, I would like to open a specific child table's form depending on whether a checkbox field of the parent table is checked or not. In other words I would like to display different child forms depending on the value of a parent table field. Is there a way to achieve that? I know it is possible to set form rules, but that is not my goal, as each form that I created has competing form rules with the others.

Thanks.

------------------------------
Eleonora Ruffini
------------------------------
Buttons
reports and charts
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago

    You can make a button called View


    var text FormOne =URLRoot() & "db/" & dbid() & "?a=dr&dfid=2&rid=" & [Record ID#];
    var text FormTwo =URLRoot() & "db/" & dbid() & "?a=dr&dfid=10&rid=" & [Record ID#];

    IF([My Checkbox]=true, $FormOne, $FormTwo)

    Then you will probably need a duplicate of the field if you want to edit.  But change the dr to er. 

    If you want to stop users to not use the native view and edit buttons, then you put these on the report and deselect the report configuration checkboxes to Allow View and Allow Edit. 

     



    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • EleonoraRuffin1's avatar
      EleonoraRuffin1
      Qrew Member
      3 years ago
      That works. Thank you!

      ------------------------------
      Eleonora Ruffini
      ------------------------------