>>This seems line an elementary question, but it's got me a bit puzzled. When the user is entering a new record, how do you check to be sure a field doesn't have a duplicate value without moving the record pointer? This also would have to take into account buffering. It seems as though I've done this before, but my head is in a bit of a muddle today and it's not coming to me.
>>
>>Thanks,
>>
>>Michelle
>
>Hi Michelle.
>
>The other's suggestions will certainly work, but you might also want to consider VFP 6's INDEXSEEK function. This will let you seek a value in the same work area without moving the record pointer.

Yeah, I believe someone mentioned that. I didn't know it was for VFP 6, though. I guess that won't work.

Thanks,

Michelle