>Terry, thanks for your reply, I'm going to change from numeric to character as you suggested. I found the source of my problem, a zero record in my lotno table.
>
>Again thanks, I'm going to follow your advice,
>
>
>Baxter

I am glad you found the problem. I cannot count all the time I suspected VFP was failing, only to learn I missed something. It's reinforcing to go through that exercise.

Also note: With complex keys, you can set exact off and point to partial matches based on left(searchstring,xxx).

Have Fun.