2 Replies Latest reply on Feb 6, 2010 10:18 AM by kennyferg

    Field Contains

    kennyferg

      Title

      Field Contains

      Post

      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