Query that produces only one record

[gheyman]

I created a query from a table that has many records.

I also had to join other tables to the main one, in the query, because the main table used "ID" numbers in foelds and I wanted to show the value the user originally selected, not its ID.

When I open the query it only shows the very first record and none of the other (1 of 1)

Any ideas what I did wrong?

Thanks

 

[Joe4]

What kind of joins do you have (INNER, RIGHT, LEFT)?
What are the relationships between the different tables (1 to 1, 1 to many, many to many)?

 

[gheyman]

Thanks, Looks like I need to do a little research on Joins. Will let you know.

 

[gheyman]

Thanks for the lead. Once I read trough the basics of Joins I was able to fix the problem.

I went to the Join Properties popup (right clicked on join line) and changed everything to "Include all records from "Main" table and only....

Thank you.

 

[Joe4]

Excellent!