Can I prevent base from putting duplicates in a table?
I have added the same name twice in a table.
Now I’ve been searching but can not find anything about this.
Is it possible to make so that no two of the same name can get into a table.
You can add a unique constraint to the column. Here’s how.
You can avoid the case sensitivity problem pointed out by tinus087 by defining the text field as VARCHAR_IGNORECASE.
good job on the link, very usefull. I already tested the VARCHAR_IGNORECASE the outcome was the same.
Tested it again with, you where right. The VARCHAR_IGNORECASE in combination with the SQL code ALTER TABLE "Customers" ADD UNIQUE ("CustomerID"); works perfect.
One way to do this is to make the ‘Name’ field the primary key. Only downside is that if you use a client ID or person ID you must fill it in yourself.
Please note that if you choose to use this, that the use of capital letters will matter. For example ‘Smith’ and ‘smith’ will create 2 different records in the database.