Martin - thanks for the response -
A follow-up question -
If I am in my select statement formatting the first of the 2 fields, for
example:
select
'(' + company + ')' as company1,
salesrepname as Salesrepname
would I need to put in the field only (company), or the result of the AS
(company1) or would it be the string formatted '('+company+')'?
Thanks,
SC
"Martin Dechev" <de*******@hotmail.com> wrote in message
news:eh**************@TK2MSFTNGP10.phx.gbl...
Set the DataTextField and the DataValueField properties of the
DropDownList control to the column names of the corresponding columns. If you have the
MSDN Library installed there are examples in the topics for these
properties.
Hope this helps
Martin
<me@privacy.net> wrote in message
news:u5*************@tk2msftngp13.phx.gbl... How can you get 2 datafields displayed in a combo box, and still return
just one of the fields?
I need to return a company name in order to help users visually
determine who a rep works for, but need only the repcode to pass on to another
variable.
SC