I have one parent list and only one child can be associated with one parent item. For example, Employee -> company access card

Each employee can have one access card and new access card can only be created when certain conditions are met in the employee list

  • You have to add some (workflow) code, SharePoint is not a Relational Database – Danny '365CSI' Engelman Mar 20 '17 at 7:53
  • @Danny'365CSI'Engelman can you please point me to any sample online, i am trying to search but my be my "search terms" are not correct. – Muhammad Sheraz Lodhi Mar 20 '17 at 8:01
  • I don't know any example which turns SharePoint into a Relational Database. – Danny '365CSI' Engelman Mar 20 '17 at 13:43

I am assuming that you have Employee list(Parent list) and Access card list (Child list) with lookup column "Employee" from parent list.

To force one to one relationship, in child list lookup column, select the option "Enforce Unique Values". This will make sure that only one item added in child list per employee.

enter image description here

| improve this answer | |
  • Thank you . This is what I was looking for. I assumed this unique was for something else – Muhammad Sheraz Lodhi Mar 22 '17 at 5:54
  • Can I apply more validations before child item is created? I mean like check if some Boolean field in parent is "true" or false? – Muhammad Sheraz Lodhi Mar 22 '17 at 6:06
  • For this you can create calculated column in Parent list. Then in formula check whether Boolean filed is True or False and if true populate employee value in this Calculated Column. Now refer this Calulated column in Lookup filed of child list. – P S Mar 22 '17 at 7:35
  • Check Accepted answer at below link, this will help you sharepoint.stackexchange.com/questions/18247/… – P S Mar 22 '17 at 7:35

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.