I have a list of departments. This list will change over time adding new departments and "deactivating" others (because of structural changes).

I would like to use this list as a look-up for other lists, but I would only want to look-up the active departments (can be detected by a bit field "Deactivated") which should be false, when the department is active...

I'm sure this can be done, but how?

Kind regards, noesgard

I have a list of departments. This list will change over time adding new departments and "deactivating" others (because of structural changes).

I would like to use this list as a look-up for other lists, but I would only want to look-up the active departments (can be detected by a bit field "Deactivated") which should be false, when the department is active.

I'm sure this can be done, but how?