0 Replies Latest reply on Jan 24, 2013 12:30 PM by petrie

    3 way join table first record joins all 3 tables, following records only per-to-per

    petrie

      Hi,

       

      I am new here and quit new in FM world but have a silly question regarding join tables for more than two tables. I have created three table join

      Table 1:

      id1

      text

       

      Table 2:

      id2

      text

       

      Table 3:

      id3

      text

       

      Join table:

      id

      id1

      id2

      id2

       

      I built a Layout for first table having two portals on it, showing records from table 2 and table 3. The relation is through a join table.

       

      Creating a first portal record in both portals creates only one record in join table that refers to both tables (2 and 3), a three way join. For all following portal records FM creates separate join records between table 1 and 2 as well as table 1 and 3.

       

      Does anyone know why it is so and how to overcome it?

       

      Thank you in advance