I have a list called Level2Risks. I have another list (List2) where I have a lookup column on Level2Risks list and Title of Level2Risks is selected as lookup value on List2.
There are multiple Level 2 Risks of same name in Level2Risks list. Now, I want to select only one lookup value and it should select all the duplicates of same name.
The lookup in List2 is already configured to have multiple values of course.
This is really urgent and any input would be much appreciated.
Thanks in advance.