AnsweredAssumed Answered

Is there a way to prevent duplicate records for many is to many relationships?

Question asked by DarrenFrancis on Jul 20, 2012
Latest reply on Jul 20, 2012 by DarrenFrancis

Title

Is there a way to prevent duplicate records for many is to many relationships?

Post

Hi guys, I'm still trying to get used to using filemaker.

I'm trying to figure out how I can define a composite key so that I do not get duplicate records. The following example will give you an idea of the problem I face:

Activity
=====
__kp_activity
activityName
activityLocation
activityCost

ActivityParticipantList
=====
_kf_activity
_kf_participant
activityParticipantListPaymentMade

Participant
=====
__kp_participant
name
school

How do I ensure that there are no records in table ActivityParticipantList that have the same value for both _kf_activity and _kf_participant?

I've came across some articles suggesting to create a calculation field that uses both _kf_activity and _kf_participant to form  _kf_activity +"|" + _kf_participant. Is using that as the primary key to link to the work around for filemaker? Do share with me on the best way to solve this issue.

Thanks!

Outcomes