I have two Lists in the Info path form.
1. All users
2. Users with With roles where user name is looked up from the List 1.
Now in the Drop down I need to Display List of person who has set to role X in list 2 and only who are joined form List 1 to 2. I need to join list 1 and 2 as look up column shows id of users in the drop down other ...