I'm a bit rusty with Access and can't figure out what I'm doing wrong.
I have three tables
Staff Data
Salary Data
Vacation Data
The ID field of Staff data has a one to one relationship with the ID field of Salary data. The ID field of Salary Data has a one-to-one relationship with the ID field of Vacation Data.
When I enter a record directly into the Staff Data table I am given a plus sign that I can click on to enter a record into the Salary Data table for this staff member. Presumably once I fill out these fields I should be given another plus sign I can click on to fill out the fields in the Vacation Data table.
However, when I key in the Salary Data fields and try tabbing to the next cell I get an error message saying
"You cannot add or change a record because a related record is required in table 'Staff Data'"
What am I missing here?