Need Help!

[smonczka]

I am making a form where the user pulls down a list of employee names.
The data is being pulled from an SQL data source. The source has two
columns in it, first name and last name.

I would like to combine the two columns in a way that when the user
uses the drop down list both the first name and the last name show up.
I can not alter or combine the columns in the tables so this has to be
done on the front end, from within Infopath.

Could someone please point me in the right direction or send me a
reference I could read on doing this.

Thank you very much for your help,
Steve
(e-mail address removed)

 

[Scott L. Heim [MSFT]]

Hi Steve,

Here is a sample expression that I use with the Northwind Employees table:

select EmployeeID, LastName + ', ' + FirstName As FullName From Employees
Order By LastName

I hope this helps!

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[smonczka]

Scott, thank you for your post. That worked well.

Thanks
Steve