Ensuring Uniqueness of Values Stored in Database Fields

Each database field may be designate as a unique field. This ensures the uniqueness of values stored in that field across all records of that folder type (Digital Resources or Retrieval Requests) in the Digital Storage Manager database. For example, Digital Storage Manager automatically assigns the customer code field and job number field to be unique so that no two customers can have the same customer code and no two jobs can have the same job number.

Ensuring the uniqueness of database fields

1. Select Forms and Finds from the Administration menu. This will open the Forms and Finds window if it is not open, or bring it to the front if it is already open.

1. Select the folder type (Digital Resources or Retrieval Requests) whose database fields you want to view in order to designate them as unique fields.
2. Check the Unique Key column ( ) for each database field you want to designate as a unique field within the folder type. Placing a ‘check’ will instruct the SQL Server database engine to force database field values to be unique. Uniqueness of value will not be ensured for database fields for which the Unique Key column is left blank.

Note: File collection and memo fields cannot be designated as unique fields.

1. Click Save ( ). This will start enforcing the uniqueness of values stored field(s) you have created to the Digital Storage Manager database.