The join lines in the relationship tab look different, is this a different join?
the one from contacts to the join table has the crews feet and the one from the qualifications table to the join table has a line.
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
Thank you for your help. I'm not sure if this is correct, can you tell from this screen print?
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.
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
Retrieving data ...