jim,
the master table has an index on masterid alone, ie .cdx file. (order masterid).
the transaction file has indexes on (masterid + date) and a second using (masterid + trans# + anotherfield), both part of cdx. i only use the (masterid +date) on the secondary table.
thanks
frank