I have a database for a company...there's tables for billing corrections, equipment that's in customer's homes, final billing information when someone moves, etc... So rather than have things like addresses stored in every table, I could have one table for addresses, one for customer names, etc.

So I could have something like this:

tblcustomer
CustomerID (Primary Key)
CustomerFirst
CustomerLast

tbladdresses
AddressID (Primary)
CustomerID (Foreign)
HouseNumber
Street
City
State
Zip

tblproduct
EquipmentID(Primary)
CustomerID(Foreign)
EquipmentName


and so on and so forth....now my question...when I'm making forms and reports for this thing...how do I get the forms to display the actual names for, say, the customer's address, instead of the ID number?? (assuming the form isn't based on the customer table, but the address table)

Main form/Sub form designs and combo boxes.

George

sounds good to me, if I get stuck I'll post in the forms/subforms forum