3 Replies Latest reply on Apr 5, 2017 5:21 PM by gagnon1937

    Relationship Problem - Works one way only

    gagnon1937

      I have two files, A & B.  In both files there are match fields.  In file A, I set up a relationship to file B.  In a layout in file A, I  put the two match fields side-by-side, one from the parent file A and the other linked to the related file B.  The contents of those two match fields appears in those two fields for all records in file A.  The relationship works exactly as one would expect and as I have done many times in the past.

       

      However, I set up a relationship in file B to link to file A using those same two match fields.  I put the two match fields on a layout in file B.  The field resident in file B has content but the field related to file A is blank for all records of file B.

       

      Why does file A get data from file B but, using the same relationship, file B cannot get data from file A?  Files A and B have multiple occurrences of the match fields but that has not been a problem in the past.  I am running FileMaker 13 on a Mac running Mavericks.  Also tried with FileMaker 14 on a computer running El Capitan.  Same result.

       

      Additional tests using a completely separate file C.

      - A can draw data from B and C.

      - B & C can draw data from each other.

      - Neither B or C can draw relational data from A.

       

      The match fields are the same for all three files.  File A seems not to want to share data.

        • 1. Re: Relationship Problem - Works one way only
          Jaymo

          Is it possible the match field in file B is unstored?

          • 2. Re: Relationship Problem - Works one way only
            BMyers

            A quick question:  you use the word "file" above.  Do you mean table?  I'll assume that you mean table.

             

            I raised my eyebrows at this line:  "Files A and B have multiple occurrences of the match fields but that has not been a problem in the past."

             

            There isn't enough information to give a diagnoses, but it is possible that there should be a join table in there?  Take a look at the FMP documentation on join tables, and you might look at YouTube for a video demo of that.  There are several short demos.  It might just solve this.

            • 3. Re: Relationship Problem - Works one way only
              gagnon1937

              Thank you for asking about the storage option for the offending field.  First of all, the match fields in all of the files (A, B, and C) are calculations, a concatenation of a town and a school name.  In checking the storage options (indexing) for the offending field, I discovered that I had long ago defined that field as a number (FileMaker's default for a calculated field).  Once I changed it to 'text' everything now works fine.  Prior to using that field as a match field between two separate files, the field definition (number instead of text) did not have an adverse effect.  Thank you.