Need help in building drop down list and relationship
I've two tables: 1. contact persons 2. Sales Quotes.
In the table of contact persons there are several fields like customer name, contact name, Email etc.
1. Customer : ABC Company, Contact Person: Mr. X
2. Customer : ABC Company, Contact Person: Mr. Y
2. Customer: XYZ Company, Contact Person: Mr. Z
I will make a new record in Quotes table and I will enter customer name. Now there is a field for selecting Contact persons in Quotes table.
So please guide me how to create a single relationship between these two table so that I can get list of contact person for any customers selected.
For e.g. If I select ABC Company then I should get Mr. X and Mr. Y in select contact person field from Drop down.
(I have done this work using two relationships but I am unable to do the same by one relationship.)