Once you have set the indexes and primary key for a table, you can check them by clicking on the Index button in the "New Table" or "Format Table" dialog. In the Table Indexes box all the indexes set for a particular table are listed:
Under Index Name the name of the index is displayed. By default this is the same as the name of the field, in Field Name, for which the index was set (although you can rename the index here, if you wish).
Sort Order is Ascending by default - click in the box to change this to Descending. The sort order determines how certain fields are displayed when you go into Table Grid View. If you have set a Primary Key this will take precedence over any of the other indexes and the records will be sorted into ascending or descending order according to the values in the primary key field. If you have not set a primary key, then the records will be sorted according to the first index listed in the Table Indexes box. Every time you go into a table, the sort index will take account of any new records previously added and will make sure that the table is correctly sorted.
To check what kind of index has been set for a field, click anywhere in that field's row in the Table Indexes box. The two check boxes at the bottom of the dialog - Primary Key and Unique - will be activated. Together these enable you to determine the kind of index set for each field:
If Primary Key and Unique are both checked, then the index is the Primary Key (remember that only one primary key is allowed per table and that it is called unique because it does not permit duplicates)
If Primary Key is not checked and Unique is checked, then the index is Indexed (Unique) (you can have many of these in a table, but duplicate values, except for blanks, are not permitted)
If Primary Key and Unique are both not checked, then the index is Indexed (you can have many of these in a table and duplicate values are permitted)
For information on how to set indexes in the Table Indexes box, see Editing and setting indexes and primary keys.