Hello,
we want to build a form with one lookup field to another form (=customers). Depending on the selection we want to consolidate on one screen the opening of several other reports (contacts,computers, etc.). The lookup field shall be given as parameter/filter for the report, so that only the contacts of the chosen customer is shown.
When changing the lookup field / chosing a different customer, the reports should change to the newly chosen customer.
Got it managed with a workflow to build a form and to open a single report which contains all reports, but I don't want to have a report for every customer.
Any help / hint is appreciated.
Thanks.
Visual:
Customer Lookup Field -> Choose Customer
Report 1 (filtered based on upon selection)
Report 2 (filtered based on upon selection)
Report 3 (filtered based on upon selection)
....