Display different than stored

[FMD]

Hiya Gang!

Little new to FileMaker development and I need some help on this one.

I have a table that holds different categories for a contact

Table: Category

Field: pk_ID_Category

Field: Category

Then I have my Contact table with a relationship to the Category table

Table; Contact

Field: pk_ID_Contact

Field: fk_ID_Category === Category::pk_ID_Category

Field: First_Name

etc.. etc... etc..

When I designed my layout for the Contact table I wanted it to where the user would see the actual Category as opposed to the Category_ID.. I created a Value List based on the Category Table and set it to only display the second field. I assigned it to a drop down in my Layout. When the user chooses the category it is fine (displays correctly in the drop down) but once they choose the one they want the value that is displayed is the Category_ID.. which is certainly the value I want stored but I would prefer it would display the Category associated with the ID. If I choose Pop-Up it works the way I would like but pop-ups don't have the auto-type as far as I can tell..

What am I missing?

[comment]

One way to solve this is to put the Category field from Categories on the layout. Make it non-enterable to prevent accidental modification, and place it over the drop-down.

[FMD]

That seems to do the trick.. thanks for the comment.. well.... comment :