Concatenate Drop-Down Lists

[Robin1985]

I am trying to concatenate two fields from a secondary data source. This
field should be a drop-down list. The Prefix and Name should both be
displayed on this drop down list. How do I go about it?

I'm using InfoPath2003 SP1

 

[vt_asparagus]

What are you connectioning to in your secondary data source? If you
are using a database like SQL Server, write a view that will concat the
Prefix and Name into one column and then select off of the view instead
of directly off a table.

 

[Robin1985]

Thanks. I was trying to do within InfoPath, but this was my first idea.