Unique primary key

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

thanks
Guido

1 Like

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.

1 Like

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

2 Likes