I require some assistance in setting up a fairly simple Access Database system for logging and retrieving information for Scheduled Orders.
We receive an order fom a customer for a future date or dates, enter information into the database which calulates when we need to place this order with our supplier based on a lead time/delivery time given in a Stock Table.
At present I have 3 tables,
1) Containing Customer Information and Product Required
2) The Delivery Schedule for the aboce line, Qty required, Date and Date we need to place the order
3) The Supplier Stock file containing around 100k lines, Their Stock information / lead times
The main page will require 4 functions - To enter a new order, To view/edit and orders already entered, a listing of orders that need to be placed today (or over the next 3 days for weekends/holidays) and an exceptions page wher the supplier stock level has dropped below what we require or lead time has changed so the 'order date' is now in the past.
I can supply what I have already although this can be changed completely if required, the only fixed table is the supplier stock file which we receive daily in a certain format.
I anticipate that this is a very simple project for anyone who knows access and VB!