3 Replies Latest reply on May 3, 2011 10:22 AM by philmodjunk

    Corrupted relationships



      Corrupted relationships


      FileMaker Pro



      Operating system version

      OS 10.6.7

      Description of the issue

      Filemaker file A contains links to set of filemaker files (B,C,..) in a folder.
      A set of relationships is defined between files B,C,.. and file A.
      When any file (B,C,..) in the folder is updated, the set of relationships is corrupted - in fact the next relation in the list is used.

      Steps to reproduce the problem

      See above

      Expected result

      Relationships should not be affected by changing files in that folder.

      Actual result

      Relationships are corrupted and need to be corrected manually

      Exact text of any error message(s) that appear

      No error message. The wrong relation is used (see screenshot where the file with label Apr does not contain the correct link (listed below the label), but in fact the next link in the list of relationships


      Correct relationships


        • 1. Re: Corrupted relationships

          Can you explain in more detail what you mean by "When any file (B,C,..) in the folder is updated"? What kind of update? Does this update alter the name or location of the file in any way?

          Any link to an external file uses a file path to that external file--which includes at least the actual name of the file. You can see these external file references in Manage | External Data Sources.

          Under no circumstances should the relationship suddenly refer to "the next link in the list of relationships". An external data-source reference can, however, list more than one file path to the same file. In those cases, if the first path fails, FileMaker will then attempt to use the next file listed in the data source reference and this is what it is designed to do here.

          • 2. Re: Corrupted relationships

            In the example shown two files are linked (UItgaven2011.fm and Apr.fm). When an  empty version (clone) of Apr.fm is replaced by Apr.fm containing new data the  link between the two files is corrupted (observed using Edit Relationship)

            • 3. Re: Corrupted relationships

              What do the entries for these files look like in Manage | External datasources?