Query isn't working!

[Matt.Hagle]

So I am taking a course in MS Access and need to find out what is wrong with my DB and why my query isn't working. It's very simple i'm sure, but I really don't know what to even look at to try and troubleshoot why the query shows me nothing. Can anyone give me a hint/direction/something?! I hope I attached the DB correctly. Hagle_Casestudy.accdb

[June7]

There isn't a query in that db. What are you trying to accomplish?

First, determine how your data is related.

I will presume each hospital can have many doctors. Now can each doctor associate with multiple hospitals?

If the answer is yes then this is a many-to-many relationship. This requires a third 'junction' table where each record will define a doctor/hospital pair.

[Matt.Hagle]

Yeah I just deleted the query because it wasn't working. But your assumption is correct. Each doctor can be associated with multiple hospitals. And vice versa...but a doctor can only have one specialty. When I try to create the relationship between the two tables it works, but when I try to make a simple query that gets just 3 items, DoctorID, Specialty, and HosID, it gives me nothing.
When you say a Junction table, you're saying create a third table? But with what information and how do you determine that information? I am assuming that either the "normalization" or "functional dependency" processes take place here, I just don't get where. Any hints about this will be really appreciated.

[Matt.Hagle]

Also, the tables have to be 3NF. Forgot to mention that. If you can see that it is or isn't if you can just say no or yes to that. I'll try to figure out the rest. I'm not looking for "the answer". Honestly because I really do want to learn this. I just need to understand what i'm looking at. Thanks much!!

[Homegrownandy]

watch a tutorial on junction tables mate. you only ever want a one to many relationship. One doctor to many hospitals, one hospital has many doctors. This is many to many.

a junction table will define their relationship between one doctor and one hospital. each hospital and each doctor can appear on this table many times but its a one to many relationship.

Have a look and if you have questions let us know.

[Matt.Hagle]

Junction tables....gotcha. I'll try it out and post back. Thanks for the suggestions.

[June7]

Third 'junction' table where each record will define a doctor/hospital pair would be like:

tblHospDocs

ID	HospID	DocID	IsActive
1	5	3	True
2	4	3	True
3	1	7	False
4	5	8	True

Now build a query that uses all 3 tables.