Re: Child-Parent Relationships with 2 Parents

2005-08-13 Thread douglass_davis
David Blomstrom wrote: I just thought of a possible solution. Instead of listing all the phyla, orders, classes, families, genera and species in one big table, create separate tables for each taxonomic level. Each taxon would then have two parents. the genus Sus' (pigs) parents would be both

Child-Parent Relationships with 2 Parents

2005-08-12 Thread David Blomstrom
Suppose I want to create an animal kingdom database that gives me the option of displaying the following taxonomic hierarchies: 1) A bread crumbs navigation string, including ALL taxons; e.g. Animalia (kingdom) Chordata (phylum) Vertebrata (a SUBphylum) Mammalia (class) Eutheria (a SUBclass)

Re: Child-Parent Relationships with 2 Parents

2005-08-12 Thread David Blomstrom
I just thought of a possible solution. Instead of listing all the phyla, orders, classes, families, genera and species in one big table, create separate tables for each taxonomic level. Each taxon would then have two parents. the genus Sus' (pigs) parents would be both the subfamily Suinae and