>>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
>
>Just as a side note. I love the INDEXSEEK(what to seek, move the cursor(.t..f.), table to seek in, index tag to use) function in VFP6. By setting the second parameter to .F. it allows you to look for things with out moving the current record pointer. I like it so much I way over use it.
>
>Before I discovered this command I was constantly saving the current record seeking and then on failure trying to return to the old record (pain in the tail).
>
>
>Adding INDEXSEEK to what the others have already given you should make the job fairly simple for you
>
>Terry
Yet another wonderful function (which was discussed quite recently in a thread: 'Fastest way to find orphans' is keymatch().
If it's not broken, fix it until it is.
My Blog