Simple Question about Multiple Table Queries

[Access_Headaches]

I am very new to this so please don't mind my ignorance. I have a database with 2 Tables, 3 Queries, and 3 Forms. I just went into design view for query 1 (which pulled info from Table 1) and added table 2 (Show table, Add).



The problem is, once I open Form 1 which pulled data from query 1; the form is blank. When I go into design view of Form 1, I see the data from table 1 and 2 which is what I want.

So my question is: How do I see the detail of my form without removing table 2 from query 1?

[Robeen]

When I go into design view of Form 1, I see the data from table 1 and 2

How can you see data when you're in design view for a Form?

[Access_Headaches]

Sorry, I mean I see Fields from Table 1 and Table 2 in "Add Existing Fields".

[orange]

You will do yourself a major benefit by researching Normalization and Database design before getting too involved with the technical side of MS Access or any other database software package.
There are some excellent videos (free) on youtube.

[Robeen]

What happens when you run query1?
Do you get all the data you expect to see?