I don't understand something in FileMaker.
This is what I believe a fully normalized database would look like:
PhoneType (number, foreign key, referenced PhoneTypeID in table PhoneType)
That's easy to do in FileMaker, but what I have trouble is displaying the PhoneType::Text instead of the PhoneType::PhoneTypeID after it has been selected.
I've created a Value List called "Phone Type" with the first column set to PhoneTypeID and the second column set to Type and checked the "Show values only from the second field." This works well in a drop-down but once the field has been exited, the number is displayed and not the text. What am I missing?