AnsweredAssumed Answered

Need help in building drop down list and relationship

Question asked by TattwamDholakia on May 20, 2015
Latest reply on May 20, 2015 by philmodjunk

Title

Need help in building drop down list and relationship

Post

Hello

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.

Sample records:

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.)

 

Thanks

 

Outcomes