I am trying to link related fields. When I create the relationship I get the "crows foot" at the end of the line linking the two fields (see screen shot). Why is this happening?
you have to set the field in the master table with a unique value (serial number UUID or something) so you will have a one to many or a one to one relationship
Michael is right, while you've used a naming convention to indicate Primary keys (PK) and foreign keys (FK) correctly, filemaker can not tell the difference (form the name) between a keyfield and a regular number/text field. You must have an auto-enter serial or auto-enter calc of Get(UUID) in all of your Primary Keyfields.
Retrieving data ...