Query not pulling data from muliple tables

[hrseebeck]

Good afternoon! I have an issue that is probably very easy to solve but can't seem to get it right. I am working in Access 07 and in the database I have attached, I have three separate tables that list market managers (tbl_MM), Chemicals (tbl_Chemicals), and Area (tbl_Area). One market manager can have multiple chemicals and have responsibility for that chemical in more than one area. I would like to create a form where the market manager can do very little to enter estimate data for those chemicals and area he/she is responsible. My initial thought is to have a form for each market managers and a subform where they enter the estimates for each chemical and area; however, the query I used to create the subform is not pulling any data. Can someone help me understand what I am doing wrong?

Thank you.

 

[plog]

First, sub-forms are usually based on tables, so why do you need a query? Second, you have no data in your tables to generate results in a query from. Third, your query isn't a query, it looks like you brought in your tables, spent 2 seconds linking the ones you did link and then didn't even link 2 of the tables you brought in.

Again, I think the overriding question is, what is the purpose of this query? Sub-forms are generally based on tables.

 

[Mr. B]

After briefly looking at your database, I would suggest that you need to do some thinking about the design of your database.

I have attached a modified version of your database.

I have made changes to fields in your tables and even added a table. I have also create an example query that hopefully with give you some insite into what you may need to do.

Because I do not know enough about everything you are going to need to do, I cannot make specific suggestions past this point but hopefully this will get you started.

Hope this helps.