1 Reply Latest reply on Dec 24, 2010 8:28 AM by philmodjunk

    Relationship is not valid

    RickWhitelaw

      Summary

      Relationship is not valid

      Product

      FileMaker Pro

      Version

      11.0v2

      Operating system version

      10.6.5

      Description of the issue

      Today I was running a routine script that involved deleting a found set and got an error message (and I'm not going to get this exactly right) that read "This operation could not be completed because the relationship between the two tables is not valid". I HAD done some work on the schema recently, and had obviously made a mistake. However, the "operation" involved the deletion of portal rows, and the relationship between the Layout Table and the Related Table was correct. The problem was with an incorrect relationship (in a different file as well) that was quite removed. My question to the error message is "Which two tables?" Although I only had to examine the tables whose relationships I had recently changed and found the rather simple problem immediately (almost) I shudder to think of how difficult it could have been. The error message should identify the Tables.

      RW

      Steps to reproduce the problem

      See above.

      Expected result

      The error message should identify the specific tables in the invalid relationship.

      Actual result

      No specification of tables involved.