lookups in a form

message from =?Utf-8?B?QmFycnk=?= on 24 May 2004
At present i have 2 tables - a customer table that holds all the details of the customer and an order details table that lists all the details of a customers order. So far i've created a form which takes details such as the customer name and number from the customer table. I also have a subform within the form that takes the details of an order from the order table. However, currently i have to manually input the customers details into the form. Is there anyway i can lookup the customers name and number details from the customer table?
 
Albert D. Kallal replied to =?Utf-8?B?QmFycnk=?= on 25 May 2004
MS-access is a relational database.

So, all you need in the customer order table is the customer ID. Any more
information should be looked up FROM the customer table..but NOT stored.

One solution is to use a sub-form. I explain how here:

http://www.attcanada.net/%7ekallal.msn/Articles/fog0000000005.html
 

Archived message: lookups in a form (Microsoft Access)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.