Well, I've been testing the app for a month now, and finally got the go ahead from management to deploy to the company. The only issue I have deals w/ security. I have designed several reports that prompt (have a drop-down) for branch. We have over 100 branches. I'm now being told that one branch can't be allowed to run the report for another branch.

So, I need to figure out the best way to set this up so that only certain users can see certain values in the drop-down.

Has anyone else dealt w/ this yet? thanks in advance