There are certain fields that you never want to contain duplicate values. This might be a field containing the Employee ID or Invoice Number. You can easily prevent a field from having duplicate values by making it unique. In other words, for each record, the value in the field must be different.
Open the field's properties page.
In the Basics section, select the Must be unique check box.
Note: You can't make a List - User field unique. The check box does not appear in properties for this type of field.
© 1999-2018 QuickBase, Inc. All rights reserved. Legal Notices.