1

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

OldGold
  • 15
  • 5

1 Answers1

4

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

P S
  • 4,827
  • 4
  • 27
  • 50
  • Thank you . This is what I was looking for. I assumed this unique was for something else – OldGold Mar 22 '17 at 05: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? – OldGold Mar 22 '17 at 06: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 07:35
  • Check Accepted answer at below link, this will help you http://sharepoint.stackexchange.com/questions/18247/how-to-make-a-filtered-lookup-field – P S Mar 22 '17 at 07:35