It turns out that my previous database design did not work properly. I was using tables w/out any kind of relationships between them. I'm re-doing the database and I have come up w/ the following ER diagram. Can someone take a look at it?
http://home.comcast.net/~deepuks/er.gif
thanks!