I am going to develop small application for Parts Management System in C# Language with backend SQL Server 2000.
I have three tables,
Parts_Stock_Table
Parts_Allotment_table
Parts_Status_Table
Scenario,
I have added & Actual part no 'KPL-900' is 10 Qty in Parts_Stock_Table, I have allotted 2 out of them to such a Jobwork, now I want deduct 2 qty from Parts_Stock_Table and shown Actual 8 in Parts_Stock_Table and another one process will be done same time in Parts_Status_Table that part no 'KPL-900' is available if, parts Qty lower than 5 then show 'Qty Lower Position' and when its goes 0 then show 'Parts not available' .
These messages look like in colours 'Parts Available' for Green, 'Qty Lower Position' for Orange and 'Parts not available' for Red. I want urgent solutions, Please do needful my friends…