4 Replies Latest reply on Jul 20, 2012 8:34 AM by DarrenFrancis

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

    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!