Forum Discussion
Sharepoint Lists many-to-many relation
Hello, It sounds to me like a very common and simple scenario, but I wasn't able to find any solution. Have this scenario: Two tables (Sharepoint lists): Products and ProductGroups. One Produc...
Viko2020 First,we should understand that SharePoint isn't a replacement for a real database system. It doesn't handle relationships as well as say SQL. In that regard, you can't do a many-to-many relationship in the way you are trying to do without some type of custom work that would keep your data in sync between the lists.
Second, in regards to a database design for a many-to-many relationship... the standard construct would be to have a third table, called and intersection table. This table is where you could store the relationships for the Product and the Product Groups. In this, you could have a list of Products, and a List of Product groups. Your intersection table would have a look up to both of those lists.