There is a database in MS Access. The table has the name of the part and the date the part was processed. In one day can not handle more than one part of the same name. I need to somehow provide for this when constructing the database. I tried to make the name of the part the main key, and simply add the date to the indexes (through the table designer, the indexes). But I still can not insert into the table two identical part names on different days. Tell me how to tell MS Access that my key consists of two fields? According to the description of the help did not help:

  1. Open the table in design mode.
  2. Click the Indices button on the toolbar.
  3. In the first empty row of the Index column, enter the index name. For an index, you can use either the name of one of the fields being indexed or another suitable name.
  4. In the Field Name field, click the list expansion button and select the first field for which you want to create an index.
  5. In the next row of the Field Name column, specify the second field to be indexed. (Leave the Index field blank for this row.) Repeat these steps for all fields that you want to include in the index.

    1 answer 1

    1. In the designer of the table with Ctrl, select the 2 fields for the key.
    2. Put the key on these highlighted fields. enter image description here

    enter image description here