Discussions

  • 1.  Child table form based on parent's field value

    Posted 22 days ago
    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
    ------------------------------


  • 2.  RE: Child table form based on parent's field value

    Posted 22 days 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
    ------------------------------



  • 3.  RE: Child table form based on parent's field value

    Posted 19 days ago
    That works. Thank you!

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