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

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.

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 ]

You can use some Javascript to do this. Have a look at using the 'onchange' element of the 'input' tag.

Garry