3 Replies Latest reply on Feb 4, 2010 12:08 PM by mrvodka

    Cross-linking child and parent tables

    metroart

      Title

      Cross-linking child and parent tables

      Post

      I want to create two parent tables -- P1 and P2 -- with one-to-many relationships to two different child tables -- C1 and C2 -- and allow C1 and C2 to become members of either P1 or P2 or both -- and have all the C1 and C2 members appear together in single portals on the P1 and P2 layouts.
       
      I'm having difficulty figuring out how to do this. Any suggestions?

        • 1. Re: Cross-linking child and parent tables
          mrvodka
            

          Please state your actual names instead of the abstract ones as it will help us.

           

          What is the purpose here of these tables. Perhaps we can offer insight to your structure.

          • 2. Re: Cross-linking child and parent tables
            metroart
              

            Dear Mr. V,

             

            It's a FM solution for a town historical society's collection -- the main purpose is to allow family members to research the collection and find out information about their ancestors and to connect these bits and pieces to the town's history.

             

            The collection contains about 10,000 Objects (photos, documents, etc). Many of these have already been grouped into many Catalogs [C1], according to common subject matter. Many Objects have also been grouped together with many individual Person records [C2] e.g. photos of a Person or documents in which the Person is mentioned -- there are about 10,000 such people listed in the town's census records.

             

            Individual Catalogs themselves can be put into larger Groups. The Group Catalog table is the Catalog table's parent. [P1 and C1]. Individual people are members of larger Families. The Family table is the Person table's parent. [P2 and C2]

             

            But sometimes, it's useful to include one or more relevant Catalogs in a particular Family's record (along with Family Persons), and likewise it's useful sometimes to include one or more Persons in a particular Group Catalog's record (along with several Catalogs).

             

            I have no problem with getting C1's into a P1 portal, or C2's into a P2 portal, but including C1's in P2 or C2's in P1... 

             

            Any insight is much appreciated. 

             

             

            • 3. Re: Cross-linking child and parent tables
              mrvodka
                

              Look into the List () function. You can use it to grab a multi-line list of the IDs. As may may already know, in FileMaker multi-lines in a field can be used to match multiple records when used as a key field.

               

               

              Also this link may be of interest to you.

               

               

              recursive data structures