Famliy tree ideas

[toffa]

Hi There
Just need some thoughts on a breeding program i am doing. What i need is when i bring up a name that somehow its parents come up and there parents and then their parents. and so forth. I will need up to 4 generations.
is this posible or am i barkignup the wrong tree.

Toffa

 

[ProgramError]

Things to think about....

was going to sugest a ready built program such as PAF - Personal Ancestral file avaliable to download for free. do a search on it. but this only does one tree and you'll want to keep records of more than one tree I suspect.

Include fields such as
ID AUTONUMBER
sex D/B - YES NO Field Dog or D for YES B or Bitch for NO
name TEXT
Owner TEXT
Owners address 6 x TEXT
Date of birth DATE - because you can calculate the age from this
Mother INTEGER
Father INTEGER
Notes MEMO - for additional notes

a table for parent/child relationship because they can have more than one child...
Pup INTEGER relate this to the pups ID
parent INTEGER - relate this to the parents ID

another table as above but for the mates..

showing the relationships on a form may be difficult to show because of the number of pups each family can have. Try displaying them from left to right starting with the parents and working through the pups to the right, rather than fron the top down.

hope this sets you on the way


Ian Mayor (UK)
Program Error
Programmers do it one finger at a time!

 

[ProgramError]

You could also make use of subreports.



Ian Mayor (UK)
Program Error
Programmers do it one finger at a time!

 

[ZmrAbdulla]

A data model

http://www.databaseanswers.org/data_models/genealogy/index.htm

________________________________________________________
Zameer Abdulla
Help to find Missing people
My father was a realistic father; not a vending machine dispense everything I demanded for!!