title: Infopath Dropdown filtering based on lookup column values?
body: <p>I have a problem with filtering a dropdown in Infopath. I have two lists in Sharepoint. In List A there is a column which lists Company names, in list B there is a column that lists Employees. The Company names from List A are used as a lookup in List B, so that each employee has an assigned company. </p>
  
  <p>The problem arises when I need to implement filtering logic in Infopath. In infopath I have two dropdown lists that connect to each list and display all the values in those columns. I need to filter the employee based on the company selected in the first dropdown. However since the values on list B are lookup values I cannot do a straight comparsion of the two values.i have tried to filter on a couple of different fields but I can't figure out this logic. Is there a way to filter based on lookup values? </p>