M
Malinda Ewing
I am trying to create my first database to track pedigrees for a cattery (we
breed and show cats). I have created a general information entry form to
enter information about the cats (color, sex, registration numbers, sire's
name and registration, dam's name and registration, etc). I am storing the
cat information in a table named CatInfo.
I am currently using a combo-box to enter the dam and sire information
(using a query to check if the cats have already been entered in to the
CatInfo table.). What I want to do is if the sire or dam number is unique
to the CatInfo table, to automatically add this information to a new record
with the registration number and cat name.
Is there an easy way to do this?
I am using Access XP.
Thanks in advance!
breed and show cats). I have created a general information entry form to
enter information about the cats (color, sex, registration numbers, sire's
name and registration, dam's name and registration, etc). I am storing the
cat information in a table named CatInfo.
I am currently using a combo-box to enter the dam and sire information
(using a query to check if the cats have already been entered in to the
CatInfo table.). What I want to do is if the sire or dam number is unique
to the CatInfo table, to automatically add this information to a new record
with the registration number and cat name.
Is there an easy way to do this?
I am using Access XP.
Thanks in advance!