Re: Account Hierachies

Sorry, perhaps I was not clear enough when I referred to parent child relationships.
 I am talking about account numbers not people. For example numbers 1 to 9 have a parent 10 (total of 1 to 9) Parents 10, 20, ..... are grouped under parent 100 (for example) I can draw a tree representing the hierarchy but what is the best table design?
There are three parent levels
Markus

Joe "Nuke Me Xemu" Foster <joe_at_bftsi0.UUCP> wrote in message news:sbutmackee6159_at_corp.supernews.com...
> "Markus Janscha" <markus_at_janscha.co.uk> wrote in message
 news:89nqjs$3o2$1_at_gxsn.com...
>
> > Could anyone please point me to a source of information for creating
 account
> > hierarchies.
 

> > I need to make child - parent and parent - parent relationships.
> > Some data sets must only be entered into children but
> > some data sets (budgets) may have to be entered into a parent level.
 

> > The parent level would also have to be identified.
 

> > I was thinking of building recursive relationships with a parent or
 child
> > flag?
>
> What happens when children become parents themselves? I'd use a Person
> table and a separate Relationship table to encode the relationships
> between various people.
>
> --
> Joe Foster <mailto:jfoster_at_ricochet.net> Space Cooties!
 <http://www.xenu.net/>
> WARNING: I cannot be held responsible for the above They're
 coming to
> because my cats have apparently learned to type. take me away,
 ha ha!
>
>
Received on Fri Mar 03 2000 - 00:00:00 CET