No duplicates database validation

No Duplicates option allows you to validate uniqueness of your columns.

Please, see below a simple example of how to use this validation option

How to create a simple database with validation No Duplicates

1) Create a new project No duplicates

2) Create a new form No Duplicates (Enter a form name into the field)

3) Add just one field to the new form - "ID Number" with a Single line type

4) Find link Validation and click on it. In the pop-up window select No duplicate entries option and click submit. See screenshot below:

>

You can see Validation link with options you selected below the field.

Then add a new entry "record". If you try to enter another record with such a value you will see Validation No Duplicates in action.

This field has validation 'No duplicates', so you can add only one original record to the database. Hope it helps!

20.10.2009 Igor Petrushenko