>Roxanne:
>
>As an aside, I saw an interesting book in the library regarding data warehousing and database design. Darned if I can remember the name offhand, but I was searching under "database design" when I found it. Maybe it could answer some of your questions about how things should be set up in general.

There is actually alot of these out there, problem is most of what I've found is based on more distributed systems where data gets polled into one warehouse, then spread out into "data marts". My needs compared to whats been done is actually a lot simpler, but thank you for the tip.... I'll check it out. Also, if anybody else is interested in Data Warehousing, e-mail me, I have found a ton of white papers and articles on the web that have helped me figure out "how to" approach this project of mine. :)