MS Access question

[TwoSugars]

Hi people,
Probably a simple question for all you MS Access ninja's but it's got me stumped.

Basically, I want to use a drop down combo box with customer names in it. When I click a name, I would like the fields below such as address, tel number etc to be populated. I have the table set up with all the fields but I just need to know how to do this on a form.

Cheers for any help!
-TS

 

[The Hoff]

Ideally you need all your tables setup with relative data, so one table for the customers details, and another table with orders etc.

Then you need to goto the relationships manager and select the tables which need to be linked via their primary keys. So primary key for the customer table would perhaps be the surname of the person.

Design your form with the necessary elements (combo box's) and goto their properties, select a record for them to read from your tables and et voila it should work for you perfectly.