Many to Many relationship setup

[Olivier]

Hi,

I am trying to do a very basic many to many reference but Appsheet keeps on creating the wrong links and ignoring the ones I created :’(.

Here is what I do :

1. TABLES : 3 tables : Investors, Properties and Relations. The table Relations should refer to the Investors and Properties tables in order to indicate who owns what and in what percentage.

2. KEY : The key of Investors is Investor_ID, the key of Properties is Property_ID and Relations is Relation_ID

3. VARIABLES :
   in table Relations, I have 2 variables set as “Ref” : Investor_ID and Property_ID
   in table Investors, I have a variable “Relation_Link” set up as “List” with the formula "REF_ROWS(“Relations”,“Investor_ID”)
   in table Properties, I have a variable “Relation_Link” set up as “List” with the formula "REF_ROWS(“Relations”,“Property_ID”)

Normally, from what I have seen in app example & forum, everything should be fine. However, Appsheet keeps on creating 2 new ref variables in the table “Investors” every time I save the application + ignore the link to Investment table. Pretty annoying. Been there for 3 hours now.

What do I do wrong ?

Best