Contacts -< Join_Contact_Qualifi. means that from Contact you can have several Join_Contact_Qualfi. records. Reason for that is that ContactID in Contact table is your unique key and just a ordinary field in the other table.
Going from the other way I think that you have forgot to set QualificationID in Qualification table to unique value /running number
What are the OPTIONS for the field?
Sent from miPhone
That looks correct to me. you can add unquie value in Validation tab.
What so Qualification iD look like on middle table?
As far as I can remember, the vertical line indicates either a Global field or a unstored calculation, thus a "one way" relation.
With best regards Magnus Fransson.
1 of 1 people found this helpful
That's basically correct. The terminations for the relationship lines are as follows:
1) Crow's foot: Can potentially have multiple records
2) Straight line: Unique on that side
3) "T" - unindexable field, meaning the relationship can't be resolved in that direction
Note that these are based on what FileMaker knows about the field. For example, if you have a primary key based on UUID, it will probably show up as a crow's foot unless you validated it as unique. You know it's unique, but FileMaker doesn't know that.
I would like to thank everyone that offered help.
I did find the problem in the join table in the end.
Thanks again all