>If I have a table that has 500,000 records in it and I locate for number 400,000. Is there a way to locate for 400,500 without having to have VFP look at the first 400,000 records. continue() I know is used iuf you are searching for the same parameter, but I want to change the search parameter and continue where the last search finished. Also seek will not work because I want to search for multiple condition. Any suggestions?
If you truly want to search just the remainder of the table, use
LOCATE for FieldN = NewVar WHILE !eof()
That will force the LOCATE to start at the present record. Be careful, the remaining records will vary depending on the index set!
HTH