Force Entries in a Field to Be Unique

There are certain fields that you never want to contain duplicate values. This might be a field containing Employee ID or Invoice Number. You can easily protect a field from duplicate values by making it "unique" In other words, each value in the field can never match another value. Each one must be unique.

To make a field unique:

1. Open the field's properties page.

2. Within the Unique section, turn on the Require unique values for all entries in this field checkbox.

3. Click Save.

Related Topics

• Unique Formula Fields

Return to top

© 1999-2010 Intuit Inc. All rights reserved.