Linking Tables

  • Thread starter Thread starter Martin
  • Start date Start date
M

Martin

This is a continuation of an earlier question, but I have
more information that may help.

I have a "detail" table that uses a couple of "master"
tables, mainly to link to descriptions. I can create a
report that will link to one of the "master" tables with
no problem. When I try to link to the other, the report
selects no data at all. It seems like the fields
containing the inking data between the two tables do not
match.

I have checked the relationship between these two tables,
even deleting and recreating it. The fields in the two
tables are defined exactly the same, except that in
the "master" table, no duplicates are allowed.

The really weird thing is that I have a printed copy of
the report showing that this link worked a few weeks ago.
Now, when I get back to work on the project, it doesn't.
This problem is causing 3 reports in my database to bomb.

Could this be related to number of joins in my database?
(I have about 15.) I am at a complete loss. Any help
would be appreciated.

Thanks.
 
This sounds like a query/data issue, not a report issue. What do you see
when you open the report's recordsource query in datasheet view?
 
I believe I have a solution to the main problem (it was
data not matching between the tables). Now, I have
another question.

There are other calculations in this report not dependent
on this bad link. Just because this link did not find a
match, it bombed the entire report acting as if no data at
all is available. Is there a way that the report can be
set up so that this one bad feature will not crash the
entire report? In my case, if no link is found, leave the
description blank, but allow the other calculations and
processing to continue.

Thanks.
 
I have no idea what your "other calculations" are or what you mean by
"bombed the entire report". You must provide a bunch more details.
 
Maybe this analogy will help. Picture a report that
produces a purchase order. There are calculations for
such things as extended cost, subtotals, etc. But there
happens to be a part number that does not match to
the "master" table. (I know this is not "normal", but I
have to have this scenario.) So, instead of the report
generating everything except the item description, nothing
is generated at all for the entire purchase order.
 
Back
Top