• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Indexing a Field

After you've opened the table you want to change in Design view, click in the field you want to index (in this example, the Product Number field).

In the property sheet, click in the Indexed field. A down arrow appears to the right of the field.

Click the down arrow and, in the list that appears, choose Yes (Duplicates OK) or No (No Duplicates) depending on your needs.

This field now will be indexed and may require a unique entry, depending on your selection. Click the Save button on the Standard toolbar to save changes to the table.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint