Help!! order by on non base table items

[Quoted] [Quoted] Hi there...

[Quoted] Anyone got any clever methods of allowing forms 4.5 to include a non base table item in a base table block in the ORDER BY clause?

I've got a base table which brings back a foreign key (Fk) field. The Fk is used in a Post query trigger to look up the description for this field. Unfortunatley, the module specification requires that the query results are ordered by the fk description followed by items in the base table.

I'm trying to achieve this without using a view (if thats possible)

Cheers

Mark Received on Wed May 14 1997 - 00:00:00 CEST