[thelist] [DB Design] Recursive Directory Structure_applyto_pedigree

[Russell Griechen]

> node further down and expand that"
>
> now here's the question of the moment, feel free to play along at home --
>
> you know the little plus sign you get in the windows explorer folder pane?
> and how you have to click on the little plus sign to get it to explode?
and
> it only explodes one level, right?  did you know you can do that, expand
> that folder to show the folders within it, by pressing the plus sign
(either
> above the equals sign, or on your numeric keypad), or, alternatively,
using
> the right and left arrow keys? do you know what the keyboard shortcut is
to
> explode *all* folders to *all* levels?

Talk about exploding nodes...
A drop down lets user select  number of generations and the execution shows
the trees being populated...
I have been trying to find the code to execute this MySql

table Dogs:
ID            AutoNumber    Primary Key
RegName    Text
Sex            Yes/No
Dame        Long Int    Indexed, Dups OK
Sire        Long Int    Indexed, Dups OK

table DogTree:
ID            Long Int    Primary Key
Generation    Long Int
RegName    Text
Sex            Yes/No
Dame        Long Int    Indexed, Dups OK
Sire        Long Int    Indexed, Dups OK

They could have more fields, but the essential data is in
the ID, Dame and Sire fields.  The Dame and Sire fields are
foreign keys back to the ID field in the Dogs table itself.