Brandy
|
| Posted: 02/19/2004, 8:19 AM |
|
I have a table of employee names. I created a Work Order Page to add new Work orders, i chose to add employee names from a list box. The names are not in any type of order, which makes it hard to find an employee. Can someone tell me how to sort the listbox. I can't make it work, when choosing just Order By from the Data source dialog box in CCS2.
Is there a where and order by statement i can add it to do this?
thanks
Brandy
|
|
|
 |
DonB
|
| Posted: 02/19/2004, 8:51 AM |
|
Are you sure you are sorting the the datasource for the dropdown and not the
form? Sounds like the list might be in primary-key order.
--
DonB
http://www.gotodon.com/ccbth
"Brandy" <Brandy@forum.codecharge> wrote in message
news:64034e2108398c@news.codecharge.com...
> I have a table of employee names. I created a Work Order Page to add new
Work orders, i chose to add employee names from a list box. The names are
not in any type of order, which makes it hard to find an employee. Can
someone tell me how to sort the listbox. I can't make it work, when choosing
just Order By from the Data source dialog box in CCS2.
>
> Is there a where and order by statement i can add it to do this?
>
> thanks
> Brandy
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
|
