DataCombo Listfield

Does anybody have a tip on how to list more than one field on a DataCombo - specifically, I need to show Lastname, Firstname Middlename which I have as separate database fields.

[Clunietp]

Concatenate your fields into 1, then add them to the list. You might have to do this manually, I don't think the bound listbox/combobox can do this by itself...

Example of concatenation & SQL: http://www.vb-world.net/ubb/Forum3/HTML/002596.html

Are you saying this should be done on the database side, not in code? ie, I need to add another field for the concatenated ones?

[Clunietp]

I am saying that you probably can't use a bound control, and have to do this in code (unless you make a query/view to do this for you, and bind the control to that query field instead)

That's a good idea - the query/view. Thanks.