Re: Relational Design - Organisations and Contacts Addresses - Help Please

Hi!
I'll give it a try :-)

I have a similar construction in a db.

I used four tables:

tblIndividualsContacts
tblZipCodes
tblOrg
tblRegistration

tblRegistration is used for, that's right!, registration of contacts
and what organization they belong to.

tblZipCodes holds: ZipCodeID,ZipCode, City

and the rest is obvious I think.

Don't know really if this is the optimal design, but it works fine for
our company.

I think you could do without tblRegistration, if your goal is only to
register when creating a new contact. Then all registration would take
place in tblIndividualsContacts.

Hope this can help you out :-)

Kev.T skrev:

Hello,

Could someone please point me in the right direction regarding a
relational design question.

The situation is holding contact addresses for Individual contacts and
their organisations, where each organisation could have several
contacts with different addresses or the same address. Not wanting to
duplicate addresses if possible, I am thinking about a table holding
only the address info and separate tables for organisations and
contacts. But I then need to make a link from the Org and Individual
to a shared address (ie where they are the same thing).

I would greatly appreciate any guidance that can be thrown my way.


Many thanks, and I look forward to reading any responses.

Kev

.