mccainz2
asked on
How to assign multiple colums to a listfield in datacombo control
I want two fields (code,descr) to be assigned to the listfield property for my datacombo control. Its easy to assign one field from the recodset but two dont seem to work.
you can only assign 1 to show in the db combo. you could buy 3rd party controls to do this. true dbcombo is a good one. you could also not use a data bound combo and concatinate the 2 fields together in a string and then add the string to the combo box.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
just had to rewrite for t-sql. select x+y as z from source.
BTW: Most people get a little peeved when you propose answers as it locks the question. SOP here is always propose as a comment.
BTW: Most people get a little peeved when you propose answers as it locks the question. SOP here is always propose as a comment.