Blank form confusion

[Harr777]

Greetings,

I have a form that uses a query as the data source. When I have one table in the query, it opens normally. However, when I add a second joined table to the query, the form opens blank.
Could someone PLEASE tell why soemthing like this would happen.

Thanks

 

[mckenneyj]

Sounds like your join on the tables is wrong
Probably need option 2 which is 1 to many


Thanks,
John McKenney
Work Hard... Play Harder

 

[cghoga]

Are you sure the tables are set up correctly?
Do you have a key field in table1 you can relate to a key field in table2?

Without seeing your database it seems like the join cannot find matching keys in the other table.

 

[Harr777]

Thank for you replies.
One thing that I left out is that one of the tables has three primary keys. One on those primary keys matches the primary key in the other table.

 

[Harr777]

One more thing,
I change the join properties in the query. The problem now is that when I try to select the primary key from it says that the form is read-only.
Can you enter records when the record set is a query?