Example STOCK TABLE
ID UserName Item ProductionDate Qty DamageQty
------------------------------------------------------------------------------------
1 mic33 Block 18-08-2017 20 5
-----------------------------------------------------------------------------------
So from daigram above i have a record of block production and 20 was produced, i have to have a page that will have a dropdown that will hold the item produced, then txtbox for productionDate and the another textbox for Qty damaged. So when the user inserts 5 in textbox damages then select the item in dropdown then insert the excat date of that production then when the data is submitted th qty 5 will be inserted based on the production date and item selected.
<p class="">
<asp:DropDownList ID="item2" runat="server" CssClass="btn btn-default dropdown-toggle" Width="100%" Font-Bold="False" Font-Size="Larger" Visible="False">
<asp:ListItem>Interlock</asp:ListItem>
</asp:DropDownList>
</p>
<p class="">
<asp:TextBox ID="txtproductiondate" runat="server" CssClass="form-control" placeholder=" date"></asp:TextBox>
</p>
<p class="">
<asp:TextBox ID="txtdamageqty" runat="server" CssClass="form-control" placeholder="Dagameqty"></asp:TextBox>
</p>
