I have one custom SharePoint list. In the list I have 4 columns:

  • Store No
  • Store Name
  • Item No
  • Item Name

I want to make one child list in such way that the Item Name and the Store Name columns in the parent list are populated with values from the child list based on the values of the Store No and the Item No columns in the parent list.


1 Answer 1


You will have to create a list Stores with columns (Store No and Store Name) and a list Items (with columns Item No and Item Name).

In your parent list you create a column Store No with the following settings:

  • Column Type: Calculated

enter image description here

Do the same for Items

Your Answer

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

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