To simplify my app I have a Projects and Contacts table where each project can have multiple contacts. I have a specific form in the Project table called Closeout. The form is a series of questions someone from my company fills out while talking to the Contact. One of questions is to select the specific contact they talked to from a drop down list.
When a Contact is created the are assigned to a specific Project. What I am looking to do is have a drop down menu on the closeout form that lists only the project related contacts and not all contacts in the table.
I made a reverse table relationship (one contact may have multiple projects) and then used the Related Contact (reference) field to display the drop down list on the form. I used the default record picker and also made an embedded table report but in both cases the drop down list shows all Contacts in the table, and not just the ones that are specifically related to the project.
How do I make the drop down menu only show the contacts that are specifically related to the project? What am I missing?
------------------------------
David Hoover
------------------------------
Question
Drop down menu to show only related project contacts
This topic has been closed for replies.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.