Link to home
Start Free TrialLog in
Avatar of rrhandle8
rrhandle8Flag for United States of America

asked on

Database table structure

One table "COMPANIES" needs to be linked to another table "CONTACTS".  Here is the twist: the contact for each company will change over time, but we need to keep the contacts.  My initial solution was to create a join table named something like "ACTIVE_CONTACT" that would hold pairs of the Company ID and the Contact ID, but i didn't know how to prevent a duplicate Company ID from being entered in the "ACTIVE_CONTACT" table. How would I do that?

Or, maybe using a join table is not the way to go?
ASKER CERTIFIED SOLUTION
Avatar of Paul Jackson
Paul Jackson
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rrhandle8

ASKER

I've requested that this question be deleted for the following reason:

I decide to make the Company ID column unique.  
Jacko72,  I did not see your answer when I tried to delete the question.  I am awarding you now.  Thank you.