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 pa...

Buttons

reports and charts

MarkShnier__You

Qrew Legend

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

Qrew Member

3 years ago

That works. Thank you!

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

Forum Discussion

Child table form based on parent's field value