Unique primary key

[aiasp]

Hello, how to avoid that one new record is created with the same primary key of another one ?

thanks
Guido

[Dean_Artis]

When creating a new key check to see if it already exists.

If it doesn’t then great, if it does then generate a new key and check again.

[muneer]

Use the Row ID as your key and it will always be unique.