InfoPath Dev

 Hi,

 I am trying to query a single SQL Table and obtain the values FirstName and LastName (columns in the SQL Table). How would I go about concating FirstName and LastName inside the Drop Down List Box WITHOUT USING A REPEATING TABLE OR SHAREPOINT LIST AS A 'MIDDLE MAN' I believe this is achievable through the SQL statement itself but I'm not having any luck with it.

 

Thank you in advance for any helpful input!

 

 

You will have to modify the view's XSLT. To extract source files (including the XSLT) from your InfoPath form template, go to Form->Publish->Extract Source Files. Specify a folder. Now you can go into your view's XSLT file (typically View1.xslt), find the dropdown and use xpath concat command to create a composite dropdown.

I believe Greg Collins has a sample that does this - search for "dropdown concat manual XSLT edit" or something like that. It's not hard to do and this should not require an xdPreserve block (used to prevent InfoPath designer from not round-tripping the manual edits). In other words, you should be able to round-trip it using the InfoPath Designer.

I know this topic has been discussed in this forum before so please search for it. If you can't find it, let us know.

 Hi Patrick, I am trying to find the sample using the search you reference but I am not getting any results back.  I would like to accomplish the same thing outlined in this post.  Can you help me find the information?

Hi - what is your data source for your dropdown? Is it SQL or SharePoint? The approach mentioned here involves modifying the form's source files for populating the dropdown with a concatenated value which I really don't recommend if there are other alternatives. If your data source is a SharePoint list - the easiest thing to do would be to add a calculated column in your list that combines the data in the way you want.... then use that column for your display.

 Forget it, I was able to get my IT to take a look and they had me combine both fields through a SQL query in the data connection.

 Thanks Hilary, I am pulling the data from SQL and I had my IT take a look and they found it could concatenated through a editing the SQL in the data connection.

Perfect, glad they were able to help. Another option sometimes instead of modifying the SQL connection is to use a SQL view that has the data combined. And in case future thread readers want to do this in the source files: https://www.infopathdev.com/blogs/greg/archive/2004/07/08/Display-Multiple-Fields-in-a-Drop_2D00_Down-List-Box.aspx