>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

*you might (if the shift code is numeric)
*create a multiple field key/tag
use MyShiftWorkerTable in 0 exclusive
select MyShiftWorkerTable
index on str(shiftnumber,1)+workercode tag ShiftWorkerTag

if seek(str(RequestedShifNumber,1)+RequestedWorkerCode,"MyShiftWorkerTable","ShiftWorkerTag")
  * It's there, yahoo
else
  * It's not there, boohoo
endif