Re: Hierachical structures - an overview

mike.macsween.nospam_at_btinternet.com says...

> World Tour has
> Regional sections has
> Country tours has
> State tours has
> City concerts has
> Rehearsal, afternoon concert, evening concert.
 

> But the hierachy could range from that (5-10 levels would do it, I think) to
> a simple string quartet playing at a wedding - 1 level.

Why not have a table

World tour

a table

Regional section

a table

Country tour

a table

State tour

a table

City concert

& further down if necessary?

I've followed this a wee bit, and am puzzled as to why different tables cannot do what you want, as opposed to having all the data in one table - maybe you could clarify?

Paul...

-- 
plinehan  y_a_h_o_o  and d_o_t  com
C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro
Please do not top-post.

"XML avoids the fundamental question of what we should do, 
by focusing entirely on how we should do it." 

quote from http://www.metatorial.com