Join multiple tables in SynchSets

[laetitia.frost]

Hi all,

I have three tables I’d like to join via SynchSets. The three data tables are linked via different Pks/FKs and table2 is linked with both table1 and table3. Table1 and table3 can only be joined via table2 (So basically table1 <-> table2 <-> table3). I’ve added a screenshot of the SynchSet, which is not working properly. Does anybody know how to implement this?

[amanmyrat.abdullayev]

in the “sources” give all three tables IDs. Also in syncMap, you can don’t need to write three syncmaps. you can do something like this: “source”: “table_2”, “targets”: [“table_1”, “table_3”].

see the following screenshot, may be helpful: