AnsweredAssumed Answered

Choose value from repeating field based on another field

Question asked by FMNewbie on May 21, 2011
Latest reply on May 23, 2011 by FMNewbie

Title

Choose value from repeating field based on another field

Post

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??

Cheers...

Outcomes