Display Second Field's Values in Related Value List

[Rich S]

I couldn't find the answer here, but I'm sure it's been answered before so I apologize for my lack of search operator coding skills. (I looked at the FileMaker online help web page but it didn't offer an answer.)

In the attached, you can see a related value list setup for a pop-up menu. When inactive, the field shows the primary key, not the school name (from the second field.) I have the Override data formatting with value list checkbox ticked in the the Inspector (Field section) but doesn't alter the menu's display, so what else do I need to do to display the school name instead of the primary key when the field is inactive?

 

Edited March 21, 2024 by Rich S

[comment]

I am not able to reproduce the problem.

Try toggling the two settings, Include Arrow… and Override data formatting off and on again. Or see what you get using a new instance of the field.

 

[Rich S]

That worked. Thanks!

[comment]

1 hour ago, Rich S said:

That worked.

Which one? Just so we know for the next time.

[Rich S]

Sorry, I should've written a new instance of the field.