Performing a calculation automatically

[hve]

On an input screen the inputter will enter a leave date, leave hours and then select from an popup menu a three letter code. I want to transfer the leave hours to a field which name is the same as the three letter code. e.g. 1/21/01,8 hours, CWL. Transfer 8 to a field called CWL. Right now I accomplish that by clicking on a button that runs a script. However it requires the inputter to not forget to push the button. Is there a way to automate that?

[BobWeaver]

If you don't want to use a button and a script, then you have to use calculated fields. For example the CWL field would be set up as the following calculation:

CWL = If(Patterncount(Code,"CWL"),Hours,"")

and so on for each of the various fields that you want to conditionally transfer the hours into.

I'm assuming that the date, hours and 3-letter code are entered by the user into separate fields. If not, they really should be.