Hi Ramil,

>replace nQty with m.Qty
>if !isnull(m.Rev)
> replace nRev with m.Rev
>endif

If !isnull(m.Rev) is true for more than 5-10% I'ld recode to:

replace nQty with m.Qty, nRev with iif(!isnull(m.Rev), m.Rev, nRev)

This could give quite a boost depending on the data structure.

If nQty is included in ANY index at all, ALWAYS take the one-liner

I'ld also base my PK on a single field, especially when using large dbf's.
Hint: you can build that field according to old keyexpression and won't break any existing code.

Keep the number of other indicices to a minimum.

HTH

thomas