3 Replies Latest reply on Oct 24, 2013 6:55 AM by philmodjunk

    Diff Relations meaning



      Diff Relations meaning


      What is diff between following relationship?

      TableA:Site_id=TableB:Site_id and 

      TableB:Site_id=TableA:Site_id ? ?  ?

        • 1. Re: Diff Relations meaning

               There is no difference.

               The only thing matters here is , on which table you are creating a layout.

               If layout is on TableA , then
               relationship will help to relate to TableB based on same Site_id.


               If layout is on Tableb , then
               relationship will help to relate to TableA based on same Site_id.


          • 2. Re: Diff Relations meaning

                 Exactly what Saigopal Das said.  The relationship is exactly the same.


                 However, in terms of FileMaker they also include a relationship graph that have Tutorial: What are Table Occurrences?, which are based on tables but are only representations of the tables.  Usually those are taken in consideration from left to right for different things, but for the most part it doesn't matter.

            • 3. Re: Diff Relations meaning

                   All true, but storage, validation and auto-enter field options can change the "left to right" significance and how the relationship functions. One of those ID fields might auto-enter a serial number, making this a one to many relationship with the serial number field's table being the "one" side of the relationship.

                   If id has global storage or is defined as an unstored calculation in one of the two such fields, this can also greatly affect how the relationship works.