What we're working on is a database of resources that anyone in our office can easily access when someone calls with a question, so that they don't have to flip through 20 bajillion papers & such to find the answer. Just about everything is on a separate table already - but the clinical director doesn't want it that way. She wants it all in one place together, mostly because she doesn't want to have to learn any new computer stuff. That's what I'm here for.

I guess what I don't understand is this: if I relate Field A to Field B, and Field B to Field C, are those the only three fields I can have in the query? And if I make a master table of EVERYthing, then I don't really need the query, do I?

We have some other databases set up to where we can enter date parameters and find out how many calls we had in a certain period. What I thought we could do was query on certain things, for instance "depression," and have all the counselors, doctors, support groups, etc., come up, without having to navigate a master table. Maybe it doesn't work that way.

I have been going through my books and none of them make any sense. I mean, I thought I was following all the instructions but I'm not getting what I hoped for.