Access 07 Question - Drop Down Selection

[Guest]

Hi,

I have a table (vendor) that holds vendor ID, Contact Name, Contact Phone, and Contact Email fields. I have another table (master) that is holding many other fields, but includes the Contact Name, Contact Phone, and Contact Email fields.

I'm populating the master fields based only on records coming from the vendor table. So if I add in a new row, I can use a drop down to select the Contact Name from the ones input on the vendor table.

Here is what I'm trying to do: I want to select the Contact Name from the drop down. I want the Contact Phone and Contact Email to populate themselves based on the Contact ID. I could do this in CF using a bind, but I'm trying to see if there is an SQL statement I can write that would do this for me.

Thoughts?

cfwild

[Dan_Bracuk]

If you don't know how to select data by joining two tables, I have heard good things about the book, Teach Yourself SQL in 10 Minutes by Ben Forta.

Not related to your question, but storing identical data in 2 different tables is a bad idea. If you intend to write databases, it's worth your while to learn data modelling.