Single Contact Multiple Address

J

James Hahn

If you are really determined to do it this way, then your only option is to
edit the data structure for the contact table to add new fields for the
second address. And if that sounds like a very poor solution, that's
because it is. The correct solution is to establish a separate table for
addresses, so that there can be any number of addresses for any one contact.
 
V

Van T. Dinh

You have 2 different entities so you should have 2 Tables, 1 for each entity
Contact and Address.

It may even be suitable to use a third Link / Resolver Table if you want to
allow for the Many-to-Many relationship (one Contact can have many Addresses
AND one Address can be shared by many Contacts).
 
Top