Search through blog..

Wednesday, April 2, 2014

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.
 
Post a Comment