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:
CustomerID (Primary Key)
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)