simple Query not working

[TME]

I have a six table database and have a query to show all records,(at the moment) but although i have put 3 records in for testing it only shows the first record. Any help gratefully recieved i'm pulling hair out.

 

[KeithG]

Can you post your SQL

 

[ejstefl]

The case is most likely that you are using joins on fields that are null. If you are using a join, make sure the data on both tables is present, or use an outer join.

 

[TME]

I think the problem is around the relationships. Have just run the table analyser which has split the tables futher and it seems to have worked. Querry is now working. Just got to sort which tables are which now.
Thanks for quick response.
Trev