Hi All,
I am using MS Access 2007.
I have a database for Quoting system for a Printing Company , where the user generate Quotes and all confirmed Quotes turn into a job.
Akin to that, i have a table for JobQuote and PrintJob. the problem i have is, whenever the JobQuote turns out as a PrintJob, it must check for availability of Stock corresponding to the input entered in the PrintJOB fields. All Stock information are stored in Excel Spreasheet.
say for example, a particular JobQuote to be done, it needs 400 papers. i want to check in the Stock Sheet for availability of papers. if i have 1000 papers, then when i turn that JobQuote into a PrintJob, it should update the Remaining Paper Stock as 600.
At the same time, when i have inadequote stock, it should prompt the user when the Quote is turned into Job.
Could anyone tell me how to head on with this?
thanks and regards,
Asle