What's up guys,
I have "Reporting" program that is store on our server. All of our 8 store's managers have access to this program. None of them are very good with computers. Currently, the manager will type in a date range and store number and press the desired report button. The sales manager has recently found out that any manager can see any other store's reports. These reports include certain confidential data such as pay, bonuses, performance, etc.
What I would like is as follows:
At the main switchboard, you click the "Reporting" program button. A password modal pops up (no username). This password tells the program what store number to use in all of the report options.
What is the best way to accomplish this? I figured I would need to have a table with a list of passwords and store numbers. I just don't know how to actually get that store number to be used in the reports without that password having to be typed in every time (like a parameter).