Try this:

Pn=PARTNUMBER,COLOR

this should sort the dataset with a multiple orderin-by clause

Cu,
Nick Josipovic

BIT Institute
Prof. Dr. Franz Steffens
University of Mannheim
T: ++49 621 181 1621
M: ++49 179 133 44 16
S: ++49 621 181 1622
F: ++49 621 181 1618
nick.josipovic@...

> -----Original Message-----
> From: stanw1950 [mailto:stanw@...]
> Sent: Tuesday, March 05, 2002 3:58 PM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Multiple field ordering
>
>
> I want the ordering in the tib_grid to be with two fields. For
> example, I have:
>
> Ordering Items: Ordering Links:
> Pn=PARTNUMBER PARTNUMBER=ITEM=1
>
> Suppose, I want to sort by partnumber and then color. I don't want
> the sorting done separately, with another ordering item and order
> link. Since each part number can have many colors, I want to keep
> them (the part numbers) together. Can this be done? Thanks in advance.
> (Delphi 6, IBO 4.2.ga)
>
> Stan Walker
>
>