Access to manage pedigrees

  • Thread starter Thread starter Honey
  • Start date Start date
H

Honey

I am the registrar for a Horse registry and was wondering if it was possible
to create relationships between horses to manage pedigrees. That is to say,
If I register a foal and the parrents are in the database, can access fill in
the pedigree, say up to 4 generations?
 
You may want to see what is available for purchase before building your own
solution. But if I were building this, I would have a "horses" table that
contained the name of the horse and an autonumber for each horse. I'd then
have two other fields, MotherID and FatherID, which would then point to the
parents of that horse (in the same table). That would allow you to go back
pretty much as far as you have data.

HTH;

Amy
 
Back
Top