How to Add Validation on a Calculated Field

[MTG]

Hi,

I have a product table, there's an "Amount" field calculated by Quantity * Price. I want to add a custom message if the amount is over $1000.-. Not sure how I can do that. Do I need to write a script or there's easier way.

Thank you very much for any help.

-- MTG --

[Kent Searight]

I'm assuming you want this custom message to appear in a field, perhaps on an invoice.

Make that field a calculation defined as:

If ( amount > 1000 ; "custom message, blah, blah, blah..." ; "" )

Be sure to make the calc result Text.

[MTG]

Thanks for your quick response.

Actually, I don't want the message to be printed in the field. I want to have a pop up message box to remind the user if the amount is over $1000.-, it has to be approved. Also, I shouldn't define this as a text field, because the total amount of this order is the sum of each amount.

[comment]

Validate either the Quantity or the Price field (or both - depends on which are filled by the user) by calculation =

Amount ≤ 1000