Adds an index to the current table.
To display this dialog box, in the Database form, select a table, click the right mouse button, and then choose Design. Then, in the Table Structure dialog box, click the Add Index button.
Name
Allows you to type the name of the index.
Indexed Fields
Lists the indexes in the field selected in the Available Fields box.
Available Fields
Lists the fields in the current table.
Primary
If selected, indicates this is the primary index for the table.
Unique
If selected, indicates that the index entry is unique.
IgnoreNulls
If selected, indicates that fields with Null values are not included in the index.
OK
Appends the current Index definition to the current table.
Close
Closes the form when you are finished adding indexes.
Note Items, such as IgnoreNulls and Unique, are Index properties. They are described in detail in the Visual Basic Help file. Those that do not apply are not available.