Forum Discussion

TrishWehrle's avatar
TrishWehrle
Qrew Cadet
7 years ago

Formula URL button to open a form and all of the related child records

Looking for help creating a button. I have a parent table of audits and a child table of findings. Right now when people create their final report I have a button on the audit page that opens the audit (in a different form) and they pdf it. 
I also have a button on each finding that opens that record (in a different form) and they pdf all of the findings and then combine the pdf. 
I'm hoping i can create a button that opens the parent record and all associated child records at once so we only have to create one pdf.
Is this possible?

Here are the formulas for each button...
The main audit button-
URLRoot() & "db/" & Dbid() & "?a=printr&dfid=10&rid=" & ToText([Record ID#])

The child record (findings) button-
URLRoot() & "db/" & Dbid() & "?a=printr&dfid=11&rid=" & ToText([Record ID#])

Thanks!

No RepliesBe the first to reply