combobox problem (1 Viewer)

[maacky99]

I've been searching these forums but couldn't find what I'm looking for. Here's what I need - maybe I'm going about it the wrong way.

I have a table called Customers. For each customer (custid) there can be multiple contacts - contact1, contact2, etc. each with their own phone, e-mail, etc.

I have a form called New Job - when I enter a new job and select the customer - I would like to have a drop down box of the available contacts for that customer (based on custid). Everything I've seen so far only allows me to have a drop down from the same field - not multiple contact fields.

Any thoughts?

Thanks!!!!

 

[CEH]

Your question is a little confusing........ A customers contacts? Or your contacts for the customer?
At any rate... Sounds like you need a table for contacts. ContactID, Name, Number so on..... Two fields, Contact1, and contact2 in your Customer table.
On your form have two combo boxes. One for Contact1, the other for contact2. Both lookup from the same table... Contacts.
If I'm following your question correctly.. That should get you what you want.

 

[RuralGuy]

It would be better to have the <custid> as a Foreign Key in the second table and a separate record for each contact. Then you could have as many contacts as you wish and the table would be normalized.

 

[Robert88]

Hi maacky99,

Sounds like Cascading Combo boxes to me?

Check this link;

http://www.fontstuff.com/access/acctut10.htm

Robert88