We have a contact form which we use for our external store to report how much goods they recieve from us. Each field in contact form represent a product and staff punch in numbers of how much they recieve in the morning, and how much they throw away in the evening. so manager get this report in email. I want a application that store the data from the emails in database and so we can get statistics from the data. For instance how many items where recieved/throw away of product 1 between date x and date y, and other relevant statistic questions. Also i want application to take data from our ordering database (in php) and show comparison of ordered products and recieved products.
I have attached database files and database exe file for order administration. Database files need to be put in a subfolder that is inside a folder together with exe file. I will choose provider today so stay online for discussion after bid.