3 Replies Latest reply on Jun 5, 2009 5:13 PM by comment_1

    Referencing records in another table that are referencing this record

    privateer

      Title

      Referencing records in another table that are referencing this record

      Post

      Table 1  fields

      Serial Number

      Name 

      Trait1

      Trait2

      Trait3

      Trait Sum (calculation = Trait1 & Trait2 & Trait3) 

       

      Table 2 fields

      Serial Number 

      Trait Name

      Trait Description 

       

      Table 1 looks up the traits from table 2 and fills in the description in a calculation. I would like a field in Table 2, that tells me all of the fields in table 1 that are referencing it in fields Trait1, Trait2, Trait3.

       

      Can filemaker even do this?