Choose value from repeating field based on another field
FMPro 11, Mac OS
I'd like to have a "TRAVEL ICON" field on a report layout that changes depending on the value of another field in each record. Basically, it's a travel database and if the "TRAVEL TYPE" field is "flight", I'd like to display an airplane icon beside that record; a "hotel" reservation would display a hotel icon etc.
Basically what I've done so far is create a global repeating container field with all the possible icons in it, but I need a way of having it automatically choose which repetition to display in each record row based on the "TRAVEL TYPE" field.
It seems like it should be simple and I'm probably missing something obvious. Any thoughts??