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
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