InfoPath Dev

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 wise. So to get tile I have to join them Thanks,

You should be able to do this with a filter on the drop down options - select the first list for your users, then in the filter, the first drop down would be the user name from the first list, then "is equal to", then in the third drop down, use a formula. In the formula editor, pick the user name from the second list, and click the Filter Data button - this filter would be Role (in the second list) is equal to whatever field or value determines the role you want.

That worked. You are genius. Thank you so much.