how to handle a field

[Bruno]

I want to use a number field in two ways, depending on what the user does:

Let's assume this formula of two fields

number1 = number2 -1

Now two situations might happen:

1.st: If the user enters a number into field number2, I want the formula
being executed,
e.g. user enters 10 into number2 field, then we fire an event and change
the field number1 to 9

2.nd, if the user enters a number into field number1, I want no event being
fired and we ignore the formula.

How can I do this?

Regards
Bruno

 

[Rod Gill]

Try using a formula with the IF statement.

 

[JackD]

Rod,

I think you missed the key point. He wants number1 to be either directly
entered or the result of a calculation in number2. This is not possible. You
can either have a formula or you can have a field for data entry. You can't
have it be both. You could use number3 and have it equal to number1 if there
is an entry in number1 or equal to number2 otherwise. But you can't have a
formula and not a formula in the same field.