Link to home
Start Free TrialLog in
Avatar of mccainz2
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.
Avatar of jrspano
jrspano
Flag of United States of America image

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
Avatar of nomulap
nomulap

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mccainz2
mccainz2

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.