Redirect to Form populating field based on the report item that called up the form
I have a Report named "All Invoices".
I have added an Action button to that report that once clicked redirects to a Form "Worked By" where I select the staff that worked on that invoice.
That Form "Worked By" has two fields:
- Invoice Number (lookup to Form Invoices);
- Staff (lookup to Form Staff);
Is there a way to pre-populate the Invoice Number on the Form "Worked By" based on the line item on the Report "All Invoices" that caused it to be opened?
Thanks,
OV