I want to write an online database that displays 4-generation pedigrees. Can anyone point me to a tutorial/web site on how to do this? I've written several online databases in asp, but can't figure out how to do this particular algorithm. Any help appreciated.
Basically I have a list of about 400,000 horses each with a unique ID code. In each individual horse’s record there is its mother and father identified by their ID codes. ie; three columns, the horse's ID, and it's mother and father's ID. So, when you display a horse’s four generation chart, it should all link up…horse, mother father, grandparents, great-grandparents etc.. It should be a common database task, but I’ve searched everywhere on the web and in various books and can’t find how to write and link up the SQL statements. Any help/pointers would be appreciated. cheers