Jump to content

Input checking.


This topic is 8388 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi, I have two databases. One current inventory and one removed inventory. If I remove a product, I want to be able to enter the quantity, but I don't want users to be able to enter a quantity that is greater than the current quantity in stock.

So ... how do I check my input versus the quantity I have already found?

thanks

Link to comment
Share on other sites

Well you could put validatation on the field, but this would not take effect until after they had already input the record, you'd then have to send them to an error page to correct thier entry.

I suppose that you could also adjust a value list based on the actual Qty available, and then only let them choose a Qty from the value list. But this I do not know how to do.

Link to comment
Share on other sites

Yes, through an If... statement on the format file. You'll need to experiment a little, but try If status (currenterror) or If Status (currentfoundcount) or If [Field: amt] less than __, or some such.

If amount not available show Amount not available, please try again, else show Thank you for your order/adding to your cart.

You may need an inline action as well.

[ August 01, 2001: Message edited by: Keith M. Davie ]

Link to comment
Share on other sites

This topic is 8388 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.