Value Lists- Display "2nd Value" in layout field w/drop down menu
I'm working on a database in FM9 that links many items with a few possible categories. I've created a table for the items and for the categories and related the category field for the items with the ID number field for the categories. I have then created a dropdown menu to assign category with a value list based on the category ID. In "Manage Value Lists" the first field is the category ID# and the second is the category name. I've selected "Show values from 2nd field".
The dropdown menu and value list are working fine but after I make a selection on the dropdown menu the field on the layout shows the ID number from the categories table instead of the category name.
It seems like this is how the program is designed but that seems like a significant oversight. Is there any way to have a displayed field on a layout display values from a value list when the field is a drop down menu?