LOCAL lcShiftWorker

lcShiftWorker = TableName.ShiftNumber + TableName.WorkerCode

IF SEEK(lcShiftWorker, "TableName", "ShiftWork")
...
ENDIF

Where TableName is the name of your table and ShiftWork is the tag name created with:

INDEX ON ShiftNumber + WorkerCode TAG ShiftWork

If you do not combine the ShiftNumber + WorkerCode into an index, you can user LOCATE:

LOCATE FOR ShiftNumber = lcShiftNumber AND WorkerCode = lcWorkerCode

P.S. please do not leave out any "f"s in your code. < g >

>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