Question
Access 07 Question - Drop Down Selection
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
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
AdChoices