Quick background... My app has the following structure: Client>Division>System>Projects. I also have a table of contacts, all of whom are related to a client, and a division. Most are also related to a system.
When a project is created, I need to capture via conditional pulldowns the following:
1. Project issued or requested by
2. Bid requested by
I need each of these dropdowns to include only those contacts related to the project system OR the project division... Any direction on how to accomplish this would be appreciated. I've been able to modify the Contacts report "Embedded for Projects" to filter based on Project - related system or project related division. Is it possible to do something similar for the pulldowns I've mentioned??
Thank you in advance!!