Work with variable list data per employee - Nested lists

[juanherreros]

Is it feasible to work with multi-level lists, where each employee has to select a value from the second level list, the first level being the employee himself?

The objective is to be able to associate expenses at project level, where each employee only has access to a low number of projects (~10), but where the number of projects is very high (~10,000). We could be talking about +1000 employees.

Each employee would fill at expense or expense report level the custom "project combo-box", selecting the value from the list posible values for him (~10, not ~10000).

This nested lists could be maintained by customer vía web-services (concur-API)

Thanks in advance.

[rberlth · Accepted solution]

@juanherreros : Yes, in our configuration we've exactly implemented what you are talking about. During our implementation phase we created a list called "Hierarchy". This list is being updated on a daily basis from our ERP system via interface. On the top level it contains all companies, on the second level the employees and on the third level the project numbers assigned to each employee. This way the employee is only able to select from the project numbers he or she is assigned to.