InfoPath Dev

Hi,

 I'm making a data connection with a list in SharePoint which has the following "columns": Worker, Plant, Account

To be clear, each worker is a unique list record, and each worker has a specific Plant and Account.

My goal is to have an InfoPath user (in this case a Project Manager) choose their "worker" from a dropdown box, then have the Plant and Account fields in the InfoPath form auto-populate.

 To do this, I set the following (seemingly obvious) Rule for the Proj_Worker dropdown box...
   Condition: IF Proj_Worker=Worker and Proj_Worker is not blank
   Action: Set field's value: Proj_Plant=Plant and Proj_Account=Account

I'm able to choose the Worker from the SharePoint List connection as expected. For example, I can choose "Mike Jones" successfully.

Im the SharePoint List, the associated Plant and Account values for Mike Jones are "New York Plant" and "ny103" respectively.

PROBLEM: When I select "Mike Jones" (or any other worker) from the dropdown box, the Plant field is populated with "20" and Account is not filled in at all.

 PLEASE HELP!!!

 Best,

JF

Hi,

It might be helpful to create a query to the SharePoint, have it execute on load, and show its contents in the canvas, just to see what data is being returned. Even a small spelling difference would cause the filter to fail.

The "20" might be coming from a lookup columns in SharePoint. Can you check the SharePoint column data types?

Thanks.