Can't create Two Many to Many between two same tables

Report Bugs
1

Hi,

I had the following problem :
i have two tables that have 2 many-to-many relationships between them. But the editor doesn’t accept it in the many-to-many syntax :

Ref BrandManagers: User.id <> Brand.id 
Ref FavoriteBrands: User.id <> Brand.id

is it a bug or a real limitation ?

Thanks !

Best regards,

Guillaume

2

Hi @gmaison,

We currently do not allow creating two relationships with the same constraint definitions.

As a workaround, you can convert one of your many-to-many refs to a junction table.

Regards.

1 Like