Create an index, like: INDEX ON PartName + Colour TAG PartColor

HTH

---

>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