I want to create a website will be able to accept information from a sales office on the "front end" page. On the "back end" page I want the results of the compiled information.
Each sales office should have their own username/password and they should only be able to enter their own information and see their own results.
My username/login should be able to see all results.
Attached are 3 documents zipped.
Front end - this is the general idea of the functions
Back end - this is the general idea of the results page. Its missing some fields like results per rep, etc... but the general idea is there.
Example board-console - this is the example document of what we are currently using. We currently duplicate this document every 2 weeks. (you can see why I want to change).
Some of this work is already done but the database portion of it is not. See here: [url removed, login to view]