I have two data sources, both have a common field, UID (which is the userid of an individual). The second data source has 3 fields, UID, First_Name, Last_Name
on my form I have a table which has a drop down list that contains userids, and two text fields which are for first and last names. I set up a rule for the drop down list so that when the drop down value is selected, a lookup on the second data source to populate the first and last names. However when I preview the form, and select a value from the drop down nothing happens. I have also tried to do it programmatically and it fails to pull find the corresponding records in the second data source even though I can filter the list in sharepoint and see the names and user id from there. Not sure why this doesn't work... any ideas?