petrie

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

Discussion created by petrie on Jan 24, 2013

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

Attachments

Outcomes