rrhandle8
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?
Or, maybe using a join table is not the way to go?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Jacko72, I did not see your answer when I tried to delete the question. I am awarding you now. Thank you.
ASKER
I decide to make the Company ID column unique.