Re: Normalizing Tree Data

On Feb 8, 11:42 am, TroyK <cs_tr..._at_juno.com> wrote:
> On Feb 8, 10:10 am, cr113 <cr..._at_hotmail.com> wrote:
>
> > What's the simplest way to set up a relationional database with tree
> > data? I'm more interested in simplicity vs speed.
>
> <snip - see OP>
>
> People will be able to guide you better if you can expand more on what
> criteria are important to you.

Here are some specifics: I'm using Access. There will only be a few thousand records maximum in any table. Around 4-6 fields in each table. Very few concurrent users. The users need to be able to add/ edit/delete any of the nodes in the tree. There are 4 levels in the tree. Expanding the previous example it would look something like this:

Company

    Division

        Manager
            Employee