Table synch question...

[MatthewGrace]

I am new to Access... I have linked a very simple and descriptive picture ( http://tinypic.com/r/23kyaf7/6 ) as an aid to explain what I'm trying to do: After a user selects a persons name from the list (for example, "Guy 3" has been selected from the list in the pic), the very next field in the record is populated with a list of addresses for the person selected... In this example, Guy 3's addresses would be "Main 3" and "Alt 3". Also, if it matters, I was able to get that list of Guy 1-4 by entering the Design View for the table, and choosing "Lookup Wizard..." for the Data type, and Access crafts a simple SQL statement getting all names in the customer field from the Customers Table.

[pbaldy]

How about

http://www.baldyweb.com/Autofill.htm

[June7]

Surely you don't want both addresses populated into the one field? Or do you really want the combobox to show main and alternate addresses as choices in its RowSource list? The address data is not normalized and so the RowSource cannot be a simple SELECT query. Also, main and alternate addresses do not each have unique ID. All this means have to save the full address in Orders table. As Paul pointed out in referenced link, this violates relational database principle of not duplicating data.

Review this tutorial for dependent (cascading) comboboxes http://datapigtechnologies.com/flash...combobox2.html. The RowSource for the addresses combobox, with your data structure, would be like:

SELECT Address FROM (SELECT CustomerID, Main As Address FROM Customers
UNION SELECT CustomerID, Alt FROM Customers) WHERE CustomerID=Forms!Orders!CustomerID;