after a long time searching in the forum and trying different ways in Pan X I turn to the forum in hope for a solution.
I am trying to establish a m:n relationship between two tables (contacts and companies). One contact can be connected to more than one company and the company can have more than one contact. In a “normal” relational database the connection between the tables is established by a bridge table.
If I got it right, in Pan X 10.2 only joins between 2 tables are possible. So the bridge table option does not work here.
If I try the lookup function (e.g. superlookup(“Unternehmen”,|||««VAS-ID»» contains «VAS-ID»|||,|||PLZ|||,“default”,0)) I also only found a n:1 or 1:n option but not a m:n option
Is there maybe a simple solution I missed yet?
Thanks in advance,