Use of drop down list or tool tip to display code dictionaries
We have 30 years worth of data in a database that I am trying to convert to FileMaker. Since storage back then was very expensive, lots of fields were set up to store a two or four letter code in place of a much longer expansion. I would like to be able to display both the code and its expansion on a layout, but since some of the code dictionaries have more than 100 entries, radio buttons and/or check boxes are impractical. Drop down lists seem useful, but when coversion is complete, this database will be essentially "read only". Drop down lists work in browse mode and in find mode, but if you set field behavior to not enter in browse mode, the drop down list doesn't appear. I tried using a tool tip with the "valuelistitem" script step. It does show up when entry is blocked, but it only shows the codes and not the expansions.
Does anyone have any suggestions?
Thanks for your help.