WolvesAly (11/21/2011)
I am hoping that there is a way to have some sort of front end that enables the end user to click in the main database user and you can then link off to this extra department information.
That's pretty much the jobs of the developers who usually wrap those views and procs which then get sent to front ends or reports for the user.
Um, hrm. You could probably dump the data out to an access database or something like that they could play in without harming the 'real' system. But this isn't a place the end users really should be goofing around in.
- Craig Farrell
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA