How do I add a non-primary-key field that has unique values [closed]

asked 2014-11-03 04:15:11 +0200

n00b999 gravatar image

In Base, I want to add a numerical field to a table, and ensure that no duplicate value is entered into this field. I tried creating a new index for that field, but an existing form is throwing an error.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2016-03-05 18:42:15.239858

Comments

Your requirement is not clear. I assume you already have a Primary Key which is auto-increment integer type. Do you need to have an additional key field where you fill in or generate values not linked or dependent on auto-incremented series? And of course how do you use this field! It should be possible to generate a date-time dependent series as key field.

PChitnis gravatar imagePChitnis ( 2014-11-03 17:20:55 +0200 )edit