strange strange strange

I created two tables, and a relation between them. The first table contains student name
and the second table contains the attendancy data from these students. I created a query upon these two tables but it stays empty as long as there is only one line (one record) in the attendancy table. Can i force the computer to go to the next line? When i create a field and fill it with a string, via the default value the table contains only one line. Help me please.

i don;t know if this would work but try
onerrorresume
next

Well i am a bit confused as to what are you asking about.
Please elaborate the roblem in detail.
Where are you not getting any data.
If possible attach the program and send.
Thanks..

Thank's for your help.
I used the wrong join in my query.
Instead of innerjoins i had to use left joins .

In every program one makes, one has to be aware of the changes . No two things can be compared.

willem