Validating quantities

[Slobey]

Hi gang,

I am building a payroll solution and have a time sheet table. you enter a code from a job line item table and enter the qty that the employee finished. I want to validate that field so that the employee can't take more units than that line item had. I simply put a validation on it in define fields requiring that the qty not be more than the qty remaining in the line item table. The problem is that the data is being entered into a portal and until you click completely out of the portal, the validation warning doesn't pop up. A clerk could enter many many lines befor exiting and they may not even know at that point which line had too many units. Is there a way to instantly pop up a validation upon exiting the field. I know I can do it with an eventscript plug in but would like to avoid that.

Thanks in advance

Mike

[Vaughan]

You could try preventing direct access into the field, insetad use a custom dialog to accept user imput and validate the imput before editing the portal row record.