Tables question (2000/2002)

Topic

New Reply

I should have seen this coming, but that

Reply | Quote

Replies

In this situation, where the large majority of customers has only one address, I would use the following setup:

1) tblCustomers
CustomerID (unique identifier, preferably AutoNumber)
CustomerName (text)
…

2) tblAddressTypes (this is a lookup table)
AddressTypeID (unique identifier, for example AutoNumber)
AddressType (text)

3) tblAdresses
AddressID (unique identifier, preferably AutoNumber)
CompanyID (number, long integer)
AddressTypeID (number, long integer)
various fields that comprise the address (street, number, zip, …)

You can use queries to select specific address types.

Reply | Quote

I understand the logic, some of which I am using with the two tables, I have lookup tables for City, State and Postal Code.

This will not be that difficult to set up and change the database this working logic.

Thank you kindly for your time, and the push in this direction.

There may be hope for this old DOS Flat File warhorse

Do you think 8 track tapes will ever make come back

Reply | Quote