I have a table of sales order lines (sDetail); There is an index on the records which is effectively a candidate index with a key of the Order reference plus STR( line number). This is used for retrieving the lines of a particular order.I have a table of sales order lines (sDetail);