Pedigree Type Database

[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!

 

[Pieter Linden]

Allen Browne has an example on his website. look around this NG for
his website. And try not crossposting to every newsgroup on the
planet... it's bad form.