Adding Table to Report

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

Martin

I have a report that uses 3 tables. Everything seems fine
except when I add a 4th table. All the other controls
produce "ERROR" when the report is run after adding the
4th table.

To use a Purchase Order analogy, I am using tables for the
PO Line Items, Inventory Items, and Customer Info. I need
to add a table that stores the PO Comments. (I have these
in a separate table since they are not associated with the
PO Line Items, but the entire PO.) When I add the PO
Comments table to the report query, the other controls
that had worked to this point all produce the "ERROR"
message.

I need to use the PO Line Items as my query source because
it contains the keys for the data selection. It is not
practical to add the keys to the PO Comments table.

Could this be the result of a many-to-one relationship
bewteen the PO Items and the PO Comments? If so, why are
there errors in all the other controls?

Any ideas would be appreciated. Thanks.
 
Create a subreport with the PO Comments and add the subreport to the PO
Group Header section.
 
Back
Top