1 Reply Latest reply on Jan 1, 2009 2:49 PM by Jens Teich

    Field from Related Table Won't Display



      Field from Related Table Won't Display


      Two tables related by a calculation field yielding text.  Adding a field from one table to a layout on the other produces the message "This operation cannot be performed because one or more of the relationships between these tables are invalid" and displays "<Index" in place of the data.

      What are common causes of this inability to display a field from a related table?


      User of FM since v2, brand new to v9.

        • 1. Re: Field from Related Table Won't Display
          Jens Teich
             There is a checkbox in the relationship details dialog which shows up after double clicking a relationship in the relationship graph. It says 'create records via this relationship' or so. It makes for example appear a blank line in portals and allows easy creation of related records. FileMaker is so kind to fill the foreign key fields for you, which is only possible when they are writeable.

          When you use this checkbox in combination with calc fields as remote keys you will see the message you describe.