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)