drop down box selection

[newbie_204]

I have a table list of clients with respective contacts within those clients; However in some case there can be a duplicate contact with two different clients. I have a drop down in my form to auto fill the contact information for the client contact information, regardless of the drop down selection the contact information defaults to the first record entered. IE Contact 1, Contact 2, Contact 3 (same person different client) - doesn't matter which selection is used the auto fill data defaults to Contact 1. How can I fix this.

Thanks in advance.

[ranman256]

there should be 1 table for Clients,
1 table for Contacts
1 table for tClientContacts

the sub table, tClientContacts holds the key from tClients.ClientID and the key from tContacts.ContactID

tClientContacts table:
CliConID (auto)
ClientID*
ContactID*

now you should never duplicate Contacts.
the tClientContacts will never hold two [Bob Smiths on Main St in TX] for 1 client.
but two different clients CAN have this Bob smith as a contact.