Joined: 13 Jan 2009
|Posted: Tue Jan 13, 2009 10:49 am Post subject: [Solved]Building a pedigree database - what am I doing wrong
|I am just starting out breeding cats, and am trying to build a database to keep track of the pedigrees of my own cats and the studs that I take them to, etc.
I have set up two tables at present: one with the details of each cat (prefix, name, breed number, colour etc.), and a second one to enter which cats are the parents of each cat. In the 1st table the key field is CatID, which is a unique ID assigned to each cat. I need some way to link each CatID to the CatID for each of its parents.
To give an example of the sort of information:
CatName: Kennbury Tehraz
CatName: Prudence Primrose
CatName: Grathors Demelza
Say that Admewbu Prudence Primrose and Adquash Grathors Demelza are the sire and dam of Adfurbu Kennbury Tehraz. I need some way to link these, so that I can tell the database that the sire of AdfuKenn1 is AdmePrud1, and the dam is AdquGrat1.
I tried having a second table with
ID, CatID, SireCatID and DamCatID, but I couldn't then figure out how to tie those to the CatIDs in the other table. I thought I had managed and entered about 20 cats, but when I ran a report on it, I just got each CatID 20 times with the SireCatID showing every other cat.
Obviously, the end goal would be able to produce a report showing that the parents of Adfurbu Kennbury Tehraz are Admewbu Prudence Primrose and Adquash Grathors Demelza; and that the parents of Adfurbu Kennbury Tehraz are Cilipepper Inyanga Floyd and Chilipepper Sweet Sasafras, while the parents of Admewbu Prudence Primrose are Creamcounty Empire Star and Creamcounty Kennbury Bizet, etc.
I've tried reading the various tutorials that look relevant, but I'm just getting myself tied in knots.
Thanks in advance,
Last edited by Hezza1506 on Tue Jan 27, 2009 12:17 pm; edited 1 time in total