InfoPath Dev

Hi All,

I have a form that uses query fields to load a record for editing. The query fields currently are region, product, and project (These are setup as cascading). What I would like to do is add one more dropdown that concatenates first & last name so that the record pertaining to the individual can be pulled up and edited. every way I have tried to do this has led to failure. Should I be concatenating the query or data fields, in the primary or secondary source table (both are the same, required for cascading dropdowns) 

 THANKS!

Hi-

I'm thinking that you have a data connection that retrieves data from a SharePoint list. When you create this data connection, you'll have a screen where you can select the columns you wish to return. These columns will be available as queryfields (to filter) and as data fields (the data returned to the form). So if you have a FullName field in the secondary data source, within the queryFields, you want to set that as equal to the value you wish to filter on.

Does that make sense?