Finding Items in a list basis common properties with another list
I am trying to assign Parent to a particular list in a module(basically identify the parent and then create a new list basis the established parent-child relationship):
List 2: to be used for Parent List
List 3: To be created using items of List 1 as child and List 2 as parent respectively
The mapping logic is somewhat like this:
- Line Item A and B are present in my current module(list formatted) which is dimensioned by List 1
- Same line items A and B are present in another module, which is being dimensioned by List 2
- What I want is that for list item of list 1 in module 1, I check if the combination of A and B is present for some list item of List 2 in the other module
- If yes, I assign List 2 item as a parent to List 1 item
However, I want this to be dynamic i.e. the A and B columns are user driven so will be changed very frequently. Hence creating a mapping list wouldn't help as one would need to update that with every change.
What would be the ideal way to go about it?