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

    Field Contains



      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