AnsweredAssumed Answered

Field Contains

Question asked by kennyferg on Feb 6, 2010
Latest reply on Feb 6, 2010 by kennyferg


Field Contains


Using FM10 on Mac - Novicee user 


Sorry in advance if this has been asked before.


I want to check the contents of the field 'PublicationID'. If the word "Year" is contained anywhere within PublicationID I want the values in the field 'Total' to display the figure 600. If the PublicationID contains the word "Month" the other field should display 50.


I can take care of the field values easily enough but I am struggling to find whether or not the  field PublicationID contains the word "Year" or "Month"


On another program I use, I can put the statement "If PublicationID contains "Year" ..." but I can't seem to find an equivalent in FM10 


Thanks in advance