Do you add the lookup to the child form?
Do not add the lookup to the Child form, as you don’t want users to change it manually. Finally, add List or Library control to the Parent forms. In SETTINGS → DataSource, select List: Children List and Lookup Field: Parent lookup.
How to make parent child lists and forms in SharePoint?
We want the parent-child mechanism to be integrated into the existing Display Item, Edit Item, and New Item forms that SharePoint automatically generates for each list we create. The contrived example we will describe uses the following list structure: An out-of-the-box Contacts list as the parent. An out-of-the-box Tasks list as the child.
How to add library control to parent form?
Finally, add List or Library control to the Parent forms. In SETTINGS → DataSource, select List: Children List and Lookup Field: Parent lookup. This will ensure that when you open Parent Edit or Display Form, you will only see connected items in the List or Library control.
How to add parentcontact column to childtasks list?
Figure 7 below shows the result of our work: a new ParentContact column has been added to the Columns list on the List Settings page: Figure 7: New ParentContact column has been added to the ChildTasks list
Is there a lookup field for the parent list in SharePoint?
The parent list has the data source, which is the field that is the target of the lookup field. In Microsoft SharePoint Foundation 2010, you can configure a lookup field in a child list so that it places a deletion constraint on items in the parent list.
How to create a parent list in Excel?
First, create Lists that you want to use as Parent List and Children List. You can use Lists or Document Libraries for this. In the Children List/Library create a Lookup column and select Get information from: Parent List. You can choose any field to display such as Title or ID.