Hey all,
I'm working on a custom report has a request page.
On the request page I enter Order No. the next field below it on the request page is Contact No.
When I enter the Order No. the contact number defaults. How can I control that default?
For example: Order No. 3 has the location-contact: Rob contact ID 01 and the owner-contact: Zach contact ID 02.
I run the report and enter in order 3 on the request page, the field below it auto populates Zach contact ID 02 the owner-contact. My goal is to enter the order number on the first field and have the location-contact Rob show up.
The report is built on a single dataItem Contact. In order to distinguish owner-contact from location-contact I'll need to use the Customer table.
Looking at the properties of the request page field that i'd like to auto populate:
SourceExpre = VAR_ContactFilter
TableRelation: Contact.No.
Could I join Contact (the reports dataitem) to Customer on the tableRelation property of a Request Page?
What are other options for automating a fields value?
I'd be happy to explain further. Thanks so much.
*This post is locked for comments
I have the same question (0)
