I am wondering how others handle having domains for staff members. Say you have an organization which does inspections and have a maintenance staff of 50 people. With moderate turnover, you would end up with a domain (and drop-down list of staff names) in the triple digits before long. A good number of these names will be associated with old inspection records, but will not be used for new records.
The names could be removed from the domain list and remain in the data itself, but that would lead to problems upon data validation. How do you handle this situation with your organization? Am I forced to deal with a coded value domain with far too many entries compared to what can be used? Thanks in advance.