https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/6722.aspxThu, 21 Apr 2005 07:15:51 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:6722freetn0https://www.infopathdev.com:443/forums/thread/6722.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=6722Of course, could have known that myself, thanks Agni!https://www.infopathdev.com:443/forums/thread/6721.aspxWed, 20 Apr 2005 15:35:53 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:6721Agni Jonnalagadda0https://www.infopathdev.com:443/forums/thread/6721.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=6721Hi freetn, <br />I am not sure if we can populate a dropdown list by combining two fields.<br /><br />But As you said you are getting data from the database, you can change your SQL query that gets the data from the database to combine the two fields.<br />Your query can be "select (lastname+firstname as name) from nametable".<br />And you can map this field to your dropdown list control.<br /><br />Agni<br />InfopathDev Indiahttps://www.infopathdev.com:443/forums/thread/4628.aspxWed, 20 Apr 2005 14:00:51 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:4628freetn0https://www.infopathdev.com:443/forums/thread/4628.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=4628Hi all,<br /><br />Is it possible to populate a dropdownlist (or at least the display name of it) with 2 combined fields from a database? I have a table with a field for firstname and a field for lastname, and the displayname of the dropdownlist lets me only choose one of both...<br /><br />Thanks!