To limit the quantity that can be added to the cart, you would need to have another column in the cart object for available quantity. In the add to cart button, store the available quantity for the item. then you can create a calculation that rests the quantity to the available quantity if the user tries to add a value above it, for example:abs([Quantity] > [AvailableQuantity])?[Quantity] = [AvailableQuantity]:''
That will work fine on the Add to Cart page but will it also work on the View Cart page where customers can also change quantity?
So I create a new column in the cart:
"AvailableQuantity"
...which is binded to the RemainingInventory field from the product recordset, right?
Problem is, my Add to Cart page uses the onchange event that Ray put in place so if a user selects a particular combination of variables (colour, dimmable or sensor) the product code and price may change. Therefore, the RemainingInventory value needs to dynamically change too doesn't it:?
It's that part of it that I'm struggling to conceptualise to be honest because I wasn't involved in, nor do I profess to understand, what Ray has put in place.
I, therefore, feel a bit railroaded into another Premier Support session (having already paid $198 for the onchange event) so I'm hoping that you can help me out, or at least offer advice on how best to proceed, in the forum here.
Thank you
NJ
