there a way for me to sort my 'part' table using 2 fields without having to store the result in another new table as in:
Eg. select part
sort to temp on partname, colour

Hi Susan,

Like Erik said, What do you need exactly, change the physical order of your records or only change them logicaly for a report or process ?. The first question is aswered by our friend. The second one, i think, can be only resolved by changing the current name of your table eg. PARTS and the issuing a select command that refers that new name and storing the ordered result into a table with the original one.

Rename PARTS .. TEMP
Select * From TEMP Into Table PARTS Order By PARTNAME, COLOUR
Delete TEMP

I Hope this give you and idea for resolving your problem ... :)


"... Whatever the route, it eventually returns to him... "