help with calcs

[VICH]

i have 12 feilds that display the a numerical limit for work that can be done that day. each day has a default value pulled from another table that contains 6 globals that define the default for each day of the week minus sunday. i had the 12 fields to go through this script to pull the correct default value:

If ( DayOfWeek ( start_date ) = 2 ; capacities::roofmon ; If ( DayOfWeek ( start_date ) = 3 ; capacities::roofteus ; If ( DayOfWeek ( start_date ) = 4 ; capacities::roofwed ; If ( DayOfWeek ( start_date ) = 5 ; capacities::roofthurs ; If ( DayOfWeek ( start_date ) = 6 ; capacities::rooffri ; If ( DayOfWeek ( start_date ) = 7 ; capacities::roofsat ; "" ) ) ) ) ) )

and that pulls the correct value and when the days across the top move it updates. but i need to be able to change those values and if i do change them they need to move with the date as well and not revert to the defaults.

example default:

mon = 1000

teus=1500

wed=800

example changed:

mon=1000

teus=1000

wed=1000

example when date moves:

teus=1000

wed=1000

thrus= 800 (default value for that day)

if it doesn't make sense say so and i will try to clarify

[Raybaudi]

Hi VICH

are those 12 fields calculated or numbers with AutoEnter option setted ?

I think ( if I understand correcty) that the solution is to set those fields as AutoEnter with Replace option.

[VICH]

they were calculated at first but i then changed them to auto enter and it doesn't work that way either