Quick Process Overview:
We are in need of an Access db to perform threshold tracking of a specific product line. Transactional data will be manually entered through an Access form to the db. After the data is entered, Access will perform a series of checks by comparing the data to the various tables containing master data and transactional data. Other functionalities include message presentation, email notifications, and no sale code assignments.
Attached are two files. A Visio flow outlining the proposed data flow process in Access and an Excel file with a proposed table summary.
Special Programmer Request:
Because of the time difference, it would be best to have a programmer from the us or Europe