I working in SharePoint Online Provider Hosted app
I have two lists having a many to many relationship
My question is: What is best way to implement this? By lookup field or list?
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this communityYou can use lookup columns to model one-to-many relationships or one-to-one relationships between lists. However, if you require a many-to-many relationship between entities in your data model, lookup columns alone are insufficient for defining the relationship. While you could use custom user interface components to manage the relationship, a better approach is to normalize the data model. Just as you would add a join table to normalize a many-to-many relationship in a relational database, you can add a join list to normalize a many-to-many relationship between SharePoint lists.
For more details:
http://msdn.microsoft.com/en-us/library/ff798409.aspx
http://www.infowisesolutions.com/blog/comments.aspx?ArticleId=91
http://www.experts-exchange.com/Database/MS_Access/Q_27777583.html