How to: Create an Index and set it as primary

How to: Create an Index

Use the following procedure to create a new index on the AJ_BookTypeID field on the AJ_BookTypeTable
NOTE: A field of data type memo or container cannot be used in an index.

To understand the example scenario - Go here

1. Locate the AJ_BookTypeTable table in the AOT.

2. Right-click the Indexes node in the table and select New Index. A new index Index1 is created.

3. Rename the index to AJ_BookTypeIDIdx

4. Drag the field AJ_BookTypeID to the index AJ_BookTypeIDIdx node.

5. In the properties sheet for the AJ_BookTypeIDIdx node, set the property AllowDuplicates to No.

How to: Set a Primary Index

Use the following procedure to set the index created in the previous procedure to be a primary index.

1. In the AOT, locate the AJ_BookTypeTable table.

2. In the property sheet for the table, set the PrimaryIndex property on the table to AJ_BookTypeIDIdx

3. Close the property sheet for the table.