>I agree that table buffering should be used, but indexseek will not by itself prevent duplicates. There is still a (small) chance that 2 users enter the same data at the same time.
>
>>With making it a primary key you might let VFP raise the error but still beware you might find yourself trapped.
>
>How?
Sylvain,
Saying trapping I meant in the sense of code I saw. seek() trying to move the pointer causing an implicit tableupdate attempt.
I tend to get values and do an unbuffered insert with error check.
Cetin