2 Replies Latest reply on Dec 13, 2013 9:03 AM by BillPlunkett

    A little clarity please on table relationships

    BillPlunkett

      Title

      A little clarity please on table relationships

      Post

           This really isn't a problem to solve, just a "why does it work this way" question.

           I have a table for contacts (which includes vendors).  I have a Ledger Transaction table and a Fixed Asset Table, both of which have a foreign key field to the contact table - which is the vendor the item was purchased from.

           I have a 1-to-1 relationship from the Fixed Asset table to the Contact table but when I attempt to place the same relationship from the Ledger to the contact table it says I must create a new occurrence of the contact table.

           Why?

           thanks,

            

            

            

        • 1. Re: A little clarity please on table relationships
          philmodjunk

               FileMaker supports a concept called "tunneling". Tunneling is the process of accessing related records more than one table occurrence away from your starting point. If you had these relationships: Table1-----<Table2-----Table3 you can use tunneling to access data in Table 3 from a layout based on table 1. But this requires that there be only one "path" from Table1 to Table3 so that it is clear that the relationship from Table1 to table2 to table3 is what must be evaluated to produce the records from table 3 that are accessible on your table1 layout. If there were also relationships from table1 to table4 to table3 there would no longer be such a clear "path" from Table1 to Table3.

               Thus, FileMaker will require you to create a new "instance"--a new Tutorial: What are Table Occurrences? of one of your tables in order to get the relationship that you need without creating any such "multiple paths" from one occurrence to another in your relationships graph.

          • 2. Re: A little clarity please on table relationships
            BillPlunkett

                 Thanks for such a clear and concise answer.  It now makes perfect sense.  Although I may never use the tunneling process it is nice to know that it's there if I should need it.

                 thanks again