Change field2 to be a calculation field and set the calculation to:
If ( field1 < 75; "default" ; "freight" )
you need a script that is like the following...
if table1::field1 > 74
set table1::field2 to "freight"
else if table1:: field1 < 75
set table2::field1 to "default"
if Weight >74
set attribute_set to "freight")
else if Weight <75
set attribute_set to "default"
this script has an error and wouldn't save, did i do something wrong
Table is called PRODUCT
Field1 is called WEIGHT
Field2 is called ATTRIBUTE_SET
so basically if the field call WEIGHT is <75 then the ATTRIBUTE_SET field should say [default]
and if the field call WEIGHT is >74 then the ATTRIBUTE_SET field should say [freight]
Okay so change ATTRIBUTE_SET to be a Calculation field and set the Calculation to:
If ( WEIGHT < 75 ; "default" ; "freight" )
In this way ATTRIBUTE_SET will always update, based on WEIGHT, without you having to run a script yourself.
that worked.. THANKS!!!
The problem with a calc is that affects all your data. If you ever need to change this, say six months from now when the break point becomes 60, then all records in your database will change. If you need accurate historical data you cannot use a calc.