Can you explain how the icons are displayed? If, for example, you have a field to display a different icon depending on the contents of another field, then a calc will do it, referencing a set of icons stored in a global repeating field. On the other hand, if the icons are graphic objects on the layout, then conditional hiding might be your answer.
• create a new Category table with fields for the category name and its associated icon (and an auto-entered primary key, of course!)
• create a value list as using fields, 1. field: Category::primaryKey, 2. field: Category::name, show second only
• rename your “main table”'s category field to categoryFK or similar to indicate that this is now a foreign key
• if necessary, change its data type to match the primary key from Category
• change the popup of categoryFK to use the new value list
• create a relationship between your main table and Category via Table::categoryFK = Category::primaryKey
• add the related field Category::icon to the layout
Thanks for the responses. I incorporated erolst's method into my solutions and it worked great.
Out of curiosity, how would one accomplish this with a calculation? The icons are graphics and I currently have them stored in container fields. I'm assuming a calculation could be made to reference the chosen value in the value list and then show the corresponding icon?
Which version of FileMaker? there are several way sot do this..
I'm on FM14, thanks.