4 Replies Latest reply on Apr 18, 2011 10:42 AM by StephenMallery

    Can't fix broken relationship

    StephenMallery

      Title

      Can't fix broken relationship

      Post

      Just completed conversion of FM 5.5 to FM 11.  Got some bugs resolved, but have run into another one I can't solve.

      One of my relationships is broken, and I can't fix it.  In the layout, it says <File Missing>.  In the map (Manage > Database > Relationships), I can open the relationship manager (Edit Relationship), but the target relationship (right-hand side) is grayed out.  I can't activate it, can't get it to assign a new file or relationship.

      I'm stuck.  It's just grayed out.  I should be able to at least assign a new relationship, but this whole thing is just gray and dead.

      Ideas?

        • 1. Re: Can't fix broken relationship
          philmodjunk

          <File Missing> indicates that the file path stored in the external data source reference no longer points to the file that it should.

          Instead of double clicking the line to edit the relationship. Double click the table occurrence box and check your external data source reference. You can correct the reference there by creating a new reference to your file or you can use Manage Data Sources to correct the error in the existing reference. I'd use Manage Data Sources if there is any chance that you have othere references to this same file in scripts, other layouts, value lists, etc as this will correct the problem for these references at the same time.

          • 2. Re: Can't fix broken relationship
            StephenMallery

            Just checked Manage External Data Sources (another innovationin FM 11 over 5.5).  The desired file did not appear on the list.  however, the file does exist in the folder (I keep all related files in one folder).  I simply opened the file.  Voila, now the relationship appears valid, and I can see the data, and all is well.

            But it leaves an unanswered question:  Why didn't FM open the file when it was prompted (when I opened that layout with the relationship linked to that file)?  It opens all the other files as needed when relationships appear.

            For now, it is fixed.  Thanks!

            • 3. Re: Can't fix broken relationship
              philmodjunk

              With out the external data source, it had no way to find and open the file. This is one of the reasons why it is recommended that you convert a set of linked older files to FileMaker 11 format all in a group. That's supposed to make sure that each file reference is correctly converted and updated.

              • 4. Re: Can't fix broken relationship
                StephenMallery

                Thanks for the help.  This seems to be fixed permanently.