Is there a function or script available to turn a field off once the count gets to zero?

I have a table that has four fields, I have the counting and subtraction working, except that the end user is able to assign keys even after all of the keys have been checked out. What I would like to find out is if there is a script or function that would turn the field off and alert the user to order more keys.

Thanks for any help.

Hal

Welcome to the forum.

Is this on a layout or a portal within the layout.

Let's say it's a portal. Set the fields to a button and create a script that checks the count and if count = 0 exit script.

If(Countfield = 0)

Show Custom Dialog(Notice; "No more keys available")

Exit Script

endif

Go To Field(Field1)

This is a quick and dirty script. If you need more help let us know.

hth

*******************************************

I had some time so I put this example together for you. I hope it takes you in the right direction.

GTRR_Test.zip

Edited February 13, 200917 yr by Guest

Thank you for the feedback, it was very helpful.