records in reports

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

Windows 95, Access 97

I have created many tables linked to one main table via an
auto-id. I have one query which sorts through them all.
I then created a report to show any one record from the
query using the auto-id.
I tested it as I went along using the same record, eg
id=12 and it works fine.
I then tried to test it with other records and it didn't
work. Of the 21 records I now have, only 8 will show the
report details, the other are blank. I found that the
query produced blank results for these 13 records but I
can not see any difference between the records. They do
not have all the fields filled in, but neither do the
working ones. I can't see any similarity between the
working ones or the non-working ones.
Can anyone help?
 
I suspect the problem is in the relationship.
Only under very specific conditions can you use the autoID
on each table as the key relation.
Maybe you can give me some more specific information or
some sample data.
Let me know.
Fons
 
Back
Top