>Aloha from Hawaii,
>
>My question is probably simple it's just that I can't figure it out:
>
>I have a table that has an index on a job shift number and worker code.
>I want to seek a record based on the job shift number and worker code.
>What command do I use to seek for this record?
>I think I'll use the SEEK command but how is the syntax for this multiple field search?
>
>Lost in Hawaii,
>Mike
To keep it simple, the following is optimizable if you have an index on Shift Number and an index on Worker Code:
seek nShiftNumber
if !eof()
locate for WorkerCode = nWorkerCode while ShiftNumber = nShiftNumber
endif
Mark McCasland
Midlothian, TX USA