create alert if field and value of database sum are more 40...

Hi my friends,

i have a question
I created a form with more field. Ok
in the form there is
cliente
materiale
week_of_finish
qta
ecc....

now i know that every the week of the year We can producer only 40 pieces.
Then when the user will write a number in qta, if this qta sum the other qta in the same week in more 40 i must do create a allert

it is possible?

thanks?

the week_of_finish is simple a number

Hi mlosito,

Sorry not to have replied earlier.

You can do this using Custom Code to check the database records to find the number committed in each week and check if that is greater than 40.

One way to do that would be to show a drop-down or Radio Button group for the weeks and to disable the weeks where the quota is full.

Bob