Displaying a Non-Display Field in Reference Field

[markmmiller09]

I am wondering if it is possible to do the following:

A,B, and C represent columns in table 1 where A is the Display field.

A

B

C

X,Y, and Z represent columns in table 2 where X is the Display field.

X

Y

Z

In a form view for table 2, is it possible to have a reference field which references a column other than the Display field, say C, from table 1. So a user can type the data related to table 1, column C and store that in the reference field on the form for table 2?

Changing the Display field for table 1 would effect other forms, therefore, I cannot take that approach.

Any ideas?

[Pradeep Sharma]

Yes that's correct.I am assuming this should fulfill Mark requirement.

[markmmiller09]

Hey Pradeep, thanks for the response, but unfortunately, as Harikrishnan mentioned, I am looking to display the actual field value. It doesn't sound like this is possible.

[geoffcox]

You could brute force it with a UI macro and Formatter to build your own field. Then you can populate its choice list anyway you want to.

[markmmiller09]

This could work... Thanks for the insight.

[sherard]

Do you have an example of how this could be done?