> I then delete the Order By Bookref stastement then I follow
> Jasons suggestion and enter the following code in the
> Beforeprepare event
>
> "sqlLookBook.SQLOrder.add('BookRef');"

I believe this should go in the OnPrepareSQL handler - Similar to the
example of adding SQLWhereItems in the Contact sample application.

> What am I missing ?
> Should I be setting the OrderingItems,OrderItemNo or
> OrderingLinks properties ?

If the requirements for these properties can be determined at
designtime, then the Ordering* properties are certainly the easier way
of managing and changing Order.

SQLWhereItems, SQLOrder etc should really only be necessary for items
that can only be determined at runtime.

HTH

Geoff Worboys
Telesis Computing