I am busy developing an application which books out stock for a function and then when the function is over book the stock back into the system. Its like a hiring application.
I am using sql express 2005 and vb.net (visual studio 2008) as my development platforms.
The tables I am currently working is Products, Quote_Header, Quote_Lines.
Products has the following columns (ProdID, CatID, ProdName, ProdQty, ProdPrice) this holds all the products for the application, per category (This part is done)
Quote_Header (Qref, Start_Date, End_Date, AccNo, Total) the employee will choose the start and end date for the quote and the customer account number will be entered, then employee will choose save and this will generate a ref number for the client. (This part is done)
Quote_Lines(ID, Qref, ProdID, Qty, Line_Total) Once the employee clicks "start quote" he will be able to add products to that ref number generated above (This part is done)
So to understand the application, stock gets booked on a start date and then returns on the end date. its a simple rental application.
So now my problem comes in with the rental of the stock, for instance if I have a product item called chair
View Complete Post