My Validation not working

[gaby78]

Can someone please take a look at my file and tell why my validation by calc is not working.

Thanks

Validation99.ZIP

[Inky Phil]

Hi Ed

I am not that well up on validation but I had a quick look at your file. Could it be because you had the validation operating only on data entry and not at all times?

Phil

[gaby78]

Hi Phil:

I tried all option combinations with no results.

[Lynn Johnson]

I think it has to do with the fact that the value of Daily Total is not updated until you commit the record. Therefore, the validation calculation is valid until the next modification.

Try making your validation calculation: Daily Total + Fees < 300.

This will produce the validation error message when the record is committed.

Lynn

[gaby78]

Thanks Lynn, it works.