Prevent or show error msg when user try to enter number when available stock is -ve or zero?

[knassoro99]

How can I prevent or show an error msg when a user tries to enter a number if the available stock is zero or negative?

Please help!

Kay

[AleksiAlkio]

You would need to add a validation to your [Number] column, but you can read the value from the "Available Stock" column. For example something like this should work.. [Available Stock]>0

[knassoro99]

Thanks my problem got solved!!

[AleksiAlkio]

You're welcome!