How can we create one to many relation by two or more lists in sharepoint
1- first you need two lists (please create them) neming: parent and child
2- in child list you need to have a look up field to ( to the parent column)
NOTE: PLEASE SELECT :ID field as extra field to your list
what we expected:
- the user want to see the related items of child when click on a parent item (in detail page)
3- in DispForm.aspx we need to edit page and add query string web part
4- edit this QueryStringWebPart and configure it to get "ID" from query string in url
5- then you should connect to QueryStringWebPart by getting filter parameter
6- we need to add custom link for adding child items to this parent item by myAddNewItemLink.js
7- when user click on new item (as child item) we need to set default value for this lookup field in NewForm.aspx by setLookupFieldValue.js