InfoPath Dev

I have a drop-down field control that uses a data connection to a SQL view containing a list of all employees. I sort this by FullNm in the data connection. There are no filters or complex statements in the SQL connection. We have two employees with the same name.  When I select them in the control, the additional employee data is the same for both employees. It's like it's not seeing them as separate database rows.  However, if I pull the same data connection into Excel, the data is correct.  It's also correct by just viewing via SQL Management Studio.  What gives?  It's like InfoPath is doing something odd with this data.  Thoughts?  I'm using InfoPath 2010.  The SQL view is on 2008 R2.

My guess is that InfoPath thought the result would be a single employee as opposed to multiple. If you modify the data connection and use the last name with two hits, InfoPath will be smarter and see that there can be two returned values. The first time you set up the data connection you probably used a query that only returned one value.