>Is 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

You mean change its natural (physical) order? Not without first copying to another table. If it is just temporary for display or processing purposes, you'll need to create an index on the desired sort order, and SET ORDER TO that index:

INDEX ON LName+FName TAG LFName
SET ORDER TO LFName

You need exclusive use of the table to create the index.