You can implement automatic lookup for any column in a table that can be accessed from the SQL Query window. An action automatically occurs when that column and an operator is selected from the Where ...

I am in an ongoing debate with my technical managers regarding accessing lookup tables and he keeps waving the "best practices" mantra at me but offers nothing concrete, I have several lookup tables ...