I have a table "Inventario" and table "Ventas" need discount item if is sale, the field "cantidad" need be modificated auto...Please can you help me??

Do you have a script for stock control??

Non credo che possano aver capito

BTW:give a look here

Thanks, but this make possible do a sale and not have items in stock. If i want sale 5 item but my stock of products is 2 this programs accept negative numbers and put in red.

I need a solution for check before make the sale if the product is in stock, is not may be show a message. I have a little idea but work only in one line not in 10 lines of the same sale. Please download the files and tell me if you have any idea.

Best regards,