I'm new to MS Access. I have a very simple plant taxonomy database that I am using to try to learn and understand the program. The database has three tables shown below:
The relationships between these tables is as below:
Referential integrity is enforced, and related fields are set to cascade updates. I then built the below form using the Form Wizard:
I chose the below fields in the wizard:
Perhaps contrary to how some might choose to build such a database, I want to see one record per Species and don't therefore want to use subforms. Hence I chose the below option, and was happy with how the resulting form was laid out.
When I attempt to add new records via this form, I am able to enter data for Families, but attempting to enter data for Genera or Species gives a "cannot add record(s); join key of table...not in recordset" error.
What have I done wrong in setting up these tables and form?