How do I calculate this out.

[Fei]

I have 4 number fields. Let say field 1 I fill in with a value = 1 field 2,3 and 4 will show 0. If I fill in value 1 into field 2, field 1,3,4 will show 0. If I fill in 1 into field 3, the rest of the field will show 0.

How do I do this?

dblentry.zip

[Raybaudi]

Hi

each option of those number fields must be definited as AutEnter calculation and calc:

( example for number1 ):

Case(

Get ( ActiveFieldName ) = "number1" ; number1;

number2 * number3 * number4 * 0

)

and so on for the others.

BTW: try the attached file

dblentryRev1.zip

[Fei]

Thanks for the help :)