Table Tips

Some of you are having trouble entering data into tables that have relationships with both "Cascade Update Related Fields" and "Cascade Delete Related Fields" checked. Try this and see if it works:

"You dragged the field symbols in the wrong direction when you created the relationship. The related table is in the Table/Query list and the primary or base table is in the Related Table/Query list. Close the Relationships dialog, click the thin area of the join line to select the join, and then press the Delete key to delete the join. Make sure that you drag the field name that you want from the primary table to the related table."