Is there a way to prevent duplicate records for many is to many relationships?
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:
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.