L
Learner2
I'm just learning Access. I need to produce a from which will allow the
imput of data for several tables. This is for the horticultural area.
One table is "Genus" another "Species" and the third "Nursery" All have
primary keys (ID) and Species and Nursery use the primary key of Genus and
Species respectively to allow for future searches. The tables are joined in
a one to many relationship Genus - Species - Nursery. My problem. When I
create the table and add the fields which need to be filled out I am blocked
from entering the necessary information for the second record. This is due
to the primary key not allowing duplicate records. How can I have the form
show "genusname" on a second form while entering a new "speciesname" and show
both "genus" and "species" while entering information on which nursery grows
this type of plant?
imput of data for several tables. This is for the horticultural area.
One table is "Genus" another "Species" and the third "Nursery" All have
primary keys (ID) and Species and Nursery use the primary key of Genus and
Species respectively to allow for future searches. The tables are joined in
a one to many relationship Genus - Species - Nursery. My problem. When I
create the table and add the fields which need to be filled out I am blocked
from entering the necessary information for the second record. This is due
to the primary key not allowing duplicate records. How can I have the form
show "genusname" on a second form while entering a new "speciesname" and show
both "genus" and "species" while entering information on which nursery grows
this type of plant?