My database will have serveral addresses for the same record, such as Home, Business, Trading, Bankers etc however not all of the records will have all these addresses.

What is the best way create the addresses information linked to the records?  Is it better to have a separate addresses table or creating the fields in the same table as the original record, then using a separate form to display the various addresses.

Thanks,

---

Reply from Alex Hedley:

I'd create a new Table AddressT with the usual
Street
City
State
Zip
Type: Home, Business, Trading, Bankers

Type could be it's own Table depending how you want to set it up.

The reason you wouldn't put it in your other Table is as you say you don't always have them filled in so they'll take up unnecessary space.