ACC: Inconsistent Behavior with Multiple-Field Primary Key

MORE INFORMATION

Steps to Reproduce Behavior

1. Start Microsoft Access and create a new database called Db1.mdb.
2. Create the following table in Design View:
   

          Table: Table1
          ------------------
          Field Name: Field1
             Data Type: Text
          Field Name: Field2
             Data Type: Text
   						

3. On the Edit menu, click Select All.
4. On the Edit menu, click Primary Key to create the multiple-field primary key.
5. Save the table as Table1.
6. On the View menu, click Datasheet.
7. Enter the following records:
   

          Field1     Field2
          ------     ------
          a          a
          b          b
   						

   
   Close the table.
8. Create the following table in Design view:
   

          Table: Table2
          ------------------
          Field Name: Field1
             Data Type: Text
          Field Name: Field2
             Data Type: Text
          Field Name: Field3
             Data Type: Text
   						

9. Save the table as Table2 without defining any primary key.
10. On the View menu, click Datasheet.
11. Enter the following records:
    

           Field1     Field2     Field3
           ------     ------     ------
           a          a          x
           b                     y
    						

    
    Do not enter any data in Field2 of the second record.
12. Close the table.
13. On the Tools menu, click Relationships. Add the Table1 table and the Table2 table to the Relationships window, and then click Close.
14. Select the Field1 field in the Table1 table and drag it to the Field1 field in the Table2 table.
15. In the Relationships dialog box, click under the Field1 field in the first column of the second row in the Table/Query grid; select Field2 from the list. Then click in the second column of the second row and select Field2.
16. Click to select the Enforce Referential Integrity check box, and then click Create. Note that Microsoft Access allows you to create the relationship, even though a record in the Table2 table contains a Null value in one of the foreign key fields.
17. Close the Relationships window and save the changes.
18. Open the Table2 table in Datasheet view. Try to delete the data in the Field2 field of the first record. Note that you receive one of the errors described in the "Symptoms" section.