September 13, 200619 yr 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
September 13, 200619 yr 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
Create an account or sign in to comment