7 Replies Latest reply on Aug 4, 2016 7:47 PM by BruceRobertson

    If Table1::field1 <75; Table1::field2 = "default";"freight"

    dansan500

      If Table1::field1 <75; Table1::field2 = "default";"freight"

       

      Im missing something I guess

      This is what i want to happen:

      Table 1

      There is a field called Field2

      If in table1 there is a field called field1, if it has a number > than 74 then I want Field2 to be populated with freight, if in field1 the number is < 75 then i want field2 to be populated with default

       

      Can you help me