C
carriey
I have a rather big database now, the main table is Tbl_MAIN (PK Record_ID)
one of the subtables is Subtbl_Inspections_MAIN (PK Insp_ID, relationship to
Record_ID) that also has a subtable Subtbl_Inspection_Deficiencies (PK
InspDef_ID, relationship to Insp_ID).
One of the reports I run based off of queries of the reports is an
Outstanding Report.
The Main report is based off of Qry_RPT_Outstanding_Inspections which has
both the Tbl_Main and Subtbl_Inspections_MAIN data in it.
The Subreport is based off of Qry_Rpt_Inspection_Deficiencies and just has
the Subtble_Inspection_Deficiencies data.
It worked great until now. It won't open anymore (there's another report
with the same issue, same queries just slightly different criteria). I can
open both the report and subreport seperately but not the subreport on the
report (it freezes everytime). Both the Insp_ID's are Long Integer and I
have tried setting up the parent child both manually and through the wizard.
There is definitely data in the subreport that relates to the report so that
is not the issue.
I went into my backend and discovered that the relationship did not have the
Enforce Referential Integrity checked although I am sure it did before. I
had to delete some orphan records and then changed the relationship. I have
confirmed that all my queries run and my forms (which all have subforms) are
working and everything seems fine except for these reports.
I have tried dragging the query into the report as a subreport, saving the
query as a subreport, recreating the subreport from scratch and through the
wizard and I still can't get them to work.
I have a ton of other reports and subreports that are very similar but based
off of other queries/tables and they all appear to be working fine.
I am not sure what more to even try but would appreciate any suggestions.
One thing I was worried about is that maybe there is something wrong with my
database and that's why the relationship was screwy in the first place -
could that be the problem? And if so, how do I fix it?
one of the subtables is Subtbl_Inspections_MAIN (PK Insp_ID, relationship to
Record_ID) that also has a subtable Subtbl_Inspection_Deficiencies (PK
InspDef_ID, relationship to Insp_ID).
One of the reports I run based off of queries of the reports is an
Outstanding Report.
The Main report is based off of Qry_RPT_Outstanding_Inspections which has
both the Tbl_Main and Subtbl_Inspections_MAIN data in it.
The Subreport is based off of Qry_Rpt_Inspection_Deficiencies and just has
the Subtble_Inspection_Deficiencies data.
It worked great until now. It won't open anymore (there's another report
with the same issue, same queries just slightly different criteria). I can
open both the report and subreport seperately but not the subreport on the
report (it freezes everytime). Both the Insp_ID's are Long Integer and I
have tried setting up the parent child both manually and through the wizard.
There is definitely data in the subreport that relates to the report so that
is not the issue.
I went into my backend and discovered that the relationship did not have the
Enforce Referential Integrity checked although I am sure it did before. I
had to delete some orphan records and then changed the relationship. I have
confirmed that all my queries run and my forms (which all have subforms) are
working and everything seems fine except for these reports.
I have tried dragging the query into the report as a subreport, saving the
query as a subreport, recreating the subreport from scratch and through the
wizard and I still can't get them to work.
I have a ton of other reports and subreports that are very similar but based
off of other queries/tables and they all appear to be working fine.
I am not sure what more to even try but would appreciate any suggestions.
One thing I was worried about is that maybe there is something wrong with my
database and that's why the relationship was screwy in the first place -
could that be the problem? And if so, how do I fix it?