Skip to main content
2 of 2
deleted 25 characters in body
Eric Alexander
  • 43.3k
  • 10
  • 54
  • 93

How to make a filtered lookup field

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?

noesgard
  • 733
  • 3
  • 9
  • 19