Single Contact Multiple Address

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I give a single contact multiple addresses without assigning a new
key ID?
 
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.
 
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).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Best solution to merge multiple Outlook contacts easily 2
Single Contact Multiple Addresses 2
Best third-party tool to repair OST files 3
Contact Management 1
Same record/Primary key in multiple tables 0
contacts template- adding a second table 3
Best Gmail Backup Tool to use in 2025? 3
primary key - concatenated or autonumber? 6

Back
Top