1

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?

1 Answer 1

1

You 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

5
  • if i use multiple value lookup field. it's low performance?
    – eaam
    Jun 19, 2014 at 12:20
  • How many items are there in library?
    – Aanchal
    Jun 19, 2014 at 12:32
  • This is the only option to provide relations between lists.
    – Aanchal
    Jun 19, 2014 at 12:33
  • Relation between Courses list and Instructors list
    – eaam
    Jun 22, 2014 at 8:39
  • You have to define some relation between these lists . so you need lookup column
    – Aanchal
    Jun 22, 2014 at 9:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.