I am creating an application using SharePoint List for storing the data. The data design would pretty much similar like if you are going to put it in a relational database, with items like many to many relationship, primary keys, foreign keys.

I would like to know what are the best practices?

Is it Possible to maintain the entity relationship data in lists ? How can the duplication be avoided?


Best practice? Don't do this in SharePoint. It's NOT a relational database system and you will be fighting it every step of the way. Every form, every workflow, every interaction will require code in some form, nothing will work out of the box.

  • how about using SPMetal? – Varun Verma Jul 2 '15 at 4:37
  • @VarunVerma, sure, that is a possibility. But so is Access or SQL. It depends on so many factors. – teylyn Jul 2 '15 at 7:33
  • Its less amount of data which is present in excel and i don't think that really need any database to store. I plan to store the data in SharePoint Lists and create relationships among them .. – Chaitu Jul 2 '15 at 18:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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