I have a strong need for reference based custom fields. On many tickets that have some development type workflows we need to assign not only an overall technician, but also a QA, UAT, and developer roles. It is not practical to maintain a custom drop down list when I have hundreds of technicians and several thousand employees- any of which could be a UAT tester.

I really require the ability to validate a custom field value against data in an existing table -- like requesters or technicians so we do not have to maintain pick lists. While we can use straight text, for reporting purposes they are susceptible to typos and can cause inconsistencies.

This would work similar in function to the way the requester field works where it looks up valid requesters in the table.