Dear all ,
I want a purchase order form where item , description ,unit price , quantity and amount an additional on load discount field has to be present which will be disabled from putting inputs . The value will directly come from the database depending upon the count value which will be provided by the user .
The relevant database for the count too is also attached herewith .
Secondly , at the top of the form there is a link written as "Show Customization Actions" .
when it is clicked , a special checkbox called "special discount" (in place of the "tax")should be available when checked will add a "special discount " column to the existing form .
Database Format are as given as follows :
From the product table : Product id , Product name & Unit Price.
From the volume table : Volume(Count) and Discount.
If count is from 1 to 5 , corresponding discount will come from database as 10 %.
if count is from 6 to 10 , corresponding discount will come from database as 12 %.
if count is from 11 to 20 , corresponding discount will come from database as 15 %.
Example link is: http://www.aynax.com/freeEstimateTemplate.php
Your help on the above will be highly felicitated and oblige .