>>Try VFP9 only
>
>>SELECT * FROM mytable ;
>> WITH (Buffering = .T.) ;
>> WHERE <New User Entry> ;
>> TO SCREEN NOCONSOLE
>>
>>IF _TALLY > 1
>> * Duplicate
>
>
>You really meant to write
>
>
>IF _TALLY > 0
>
>
>right?
It depends when you check. If after INSERT as your original code than my code is correct. If before INSERT than you're correct.
--sb--