Combobox Recursion - Report Generator - SQL

There is a simple system I have running. It is tied to a few tables in an access database. And there are different steps in this process to develop a report at the end. It's pretty much involving combobox's and choosing options and each combobox's options depends on the previous choice from the previous combobox. I talked to someone they said it should take an hour for a decent asp programmer. If they are the manager they can look at everyones names in the first combo box (employee table), and select someone or choose to do a performance analysis on all employees. If they are a sales agent it doesnt let them see this combo box and goes straight to the next page, displays their name instead of one chosen, and lets them pick an option. Then they go to the next one it asks for region and whatnot. They choose that , then it goes to the next one, and if they chose a specific criteria like that it shows the different regions, or specific criteria for whatver they chose. Then it keeps going on and on like I Said. But on every single page it has to develop or add to an SQL query. Cause what I Want to do is by the time step 5 comes, have an SQL Query built out of all these selections, so taht I can generate a report like below step 5. Either a single agent report if they chose a name from above or are an agent logged in. Or a general report, if they are a manager and chose all Employees in teh first combo box. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Windows XP ASP Classic IIS