Hi
First, i have a table Business Functions
This table has only fields Name and Parent and here I can create structures as deep as i want, in this exampl we have 3 levels. 3. Level Supplier contracts, has Parent Contract Management on leve 2, which has his parent Purchasing on level 1.
In the next step I am trying to normalize this structure for each employee. I say that Gino’s function is supplier contracts, which is level 3, and then my whish is to automatically show the higher function levels, level 2 is possible with lookup, as input we have the function level3 (linked to another record) and it gives the contract management, but to get also level 1 I would need to lookup with the level 2 field, because I need the value Purchasing as result.
Hope this makes clearer, I have also send an excel example to Karlheinz some time ago. If you need it let me know and i will send you an email.
Thank you
