what we do
wee see hirary structure in many databases

customers
articles
turnover versions
and so on

that why we ha one tabel structure

the tabel has different keys

1. structure belonggs to tabel art...
2. Name of structure (there are n structures for articles cistomers
3 key next level
4 Hierary key
the hirarchy key field ist 180 cararters long
a programm generates the hirarchie number
it looks like
123.234.345......

it always starts at the highest level and can have up to 14 levels
the . is the separator for the levels. If you have . in your numbers you need an othe one

teh programm checkes if ther is a dataset in the main tabel wher the next level information is missing and automaticly generates a referenz dataset under a secific not ( name structure missing)

During generation of the structure field the integrity of the tree is chcked an a protokoll in excel is generatet if ther are some inconsistend information (not missing, boken tree)

In the largest instalation we have 25 different structures and customer tabels up to 250.000 recards

we use DBI tree because you can ad different coulums
the treevie claas has a popup ontop and the´user can select the structure for the data the he needs.

dirk