Check for Duplicates

[cp2599]

I have resolved a many-to-many relationship between family and
individual into a table of its own. Now I don't know how to check
before adding the individuals to a new family that that combination of
individuals don't already exist for another family.

Ind Table
IndID
IndName

Fam Table
FamID
FamName

FamInd Table
FamID
IndID
ApplType (applicant or coapplicant)

 

[cp2599]

cp2599wrote:




Make (FamID, IndID) the primary key  of FamInd and that will take care of it
for you.

You must have misunderstood my dilemna. The problem is not with one
individual belonging to the same family. The problem is that I want
to make sure that the same combination of individuals (2 to be exact)
do not already exist in this table for another family. I got around
the edit by creating a support table that whenever I add, update,
delete a family, I also have to do it to this table.
FamCombo Table:
FamID
ApplicantID
CoApplicantID
This way I can check to see if the individuals exist on a family as
the same applicant/coapplicant or coapplicant/applicant combination
before adding a new family.