Re: Account Hierachies
Date: 2000/03/03
Message-ID: <sbutmackee6159_at_corp.supernews.com>#1/1
"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