>Hi,
>how would I use function "locate" to start searching from a certain record?
>Thanks,
>Tamas Szigeti

In addition to other suggestions, you can combine the FOR and WHEN clauses in a LOCATE...

LOCATE FOR some_condition WHILE Invoice_Num = lnInvoiceNo

So if your table is indexed on Invoice_Num you can...

SEEK lnInvoiceNo
LOCATE FOR some_condition WHILE Invoice_Num = lnInvoiceNo

..which would be very fast since the number of records with that Invoice_Num should be fairly small.