Re: Order by

If the view approach does not work...
[Quoted] Create a stored function that queries the description table using the key as [Quoted] a passed parameter. In the form, use this procedure in the ORDER BY property, providing the item key field name as the parameter.

You can find an example of this on metalink; search for "How to order by a non database item in a block." Or drop me a note and I'll see if I can help.

[Quoted] "Robin Quasebarth" <quasebarth_robin_r_at_solarturbines.com> wrote in message news:3906091C.66E3A78A_at_solarturbines.com...
> You might need to use a view with that element instead of a table. rq
>
> Ken Halsted wrote:
> >
> > Just wondering how I could order by a display item in a form. I have a
 form
> > that lists items (item number, description, etc).
> >
> > If Item Description is a DISPLAY item coming from another table not in
 this
> > form, how can I choose to order by the description?
> >
> > Is it possible?
> >
> > Thanks,
> >
> > Ken.
Received on Wed Apr 26 2000 - 00:00:00 CEST