Jason,

You're missing an understanding of how the SEEK() command works. Reread you're explanation of the parameters you are passing to SEEK(). I'm assuming you're a student, so I'm not going to give you the answer.

I'll give you a hint thou. How does the command you just showed know that it needs to find the matching Id in "Patron".

PF


>Hello everyone...
>
>When attempting this search I get a data type mismatch.
>The 'id' field in both my 'results' cursor and 'patron' table is numeric. The debugger is showing that both are numeric. The tag 'deleted' is on the 'patron' table and the expression on it is "deleted()".
>
>IF (SEEK(results.id, 'patron', 'Deleted'))
> expression
>ENDIF
>
>Will someone offer assistance?
>
>Thanks.
>
>Jason Nance