Allow different display fields for the same object in drop downs

What I would really like is the option to represent the same object type with multiple different display fields for different situations.

Let me illustrate this with an example.

Suppose you have an object Class Room. Class Room has a connection to object Teacher.

Suppose you have another object Pay Stub. Pay Stub also has a connection to object Teacher.

When you have a form to create or edit Class Room, you will have a drop down to select the corresponding Teacher. Teacher's display field is Name. So this drop down will show the Teacher's Name. This is what we want for this scenario.

When you have a form to create or edit the Pay Stub, you will have another drop down to select the corresponding Teacher. However, in this situation we don't want to display the Teacher's name. We would much rather display the Teacher's Employee ID. Employee ID is a field in Teacher, but it is not a display field. Right now, there is no way to get the Teacher's Employee ID to display in the drop down instead of the Teacher's Name.

Same here. Hoping for this feature to happen for a while.

The same thing was essentially asked for two years ago: https://support.knack.com/hc/en-us/community/posts/360018891932-Variable-Display-Field-when-connecting-objects-?input_string=Allow%20different%20display%20fields

But maybe we can make it happen this time around.