Report with one subreport

  • Thread starter Thread starter jeannette0373
  • Start date Start date
J

jeannette0373

I have 1 table (loan information)in a report and one sub-report using one
table (transaction history). When I run the report, the information in the
sub-report is screw, for example, I have client 1234 showing the transactions
for client 2345. I tried setting the relationships,but this doesn't make any
difference. I am kind of new on this, have Access 2003 and will love to have
some help. Thanks.
 
Have you set the proper (corresponding) Fields (or Controls) in the
properties of the Subreport Control? The record identification from the main
report's Record Source in the "LinkMasterFields" and foreign key to the main
record in the "LinkChildFields" from the RecordSource of the Report (or
Form) in the Subreport Control?

Larry Linson
Microsoft Office Access MVP

jeannette0373 said:
I have 1 table (loan information)in a report and one sub-report using one
table (transaction history). When I run the report, the information in
the
sub-report is screw, for example, I have client 1234 showing the
transactions
for client 2345. I tried setting the relationships,but this doesn't make
any
difference. I am kind of new on this, have Access 2003 and will love to
have
some help. Thanks.

__________ Information from ESET Smart Security, version of virus
signature database 4054 (20090505) __________

The message was checked by ESET Smart Security.

http://www.eset.com
Click to expand...



__________ Information from ESET Smart Security, version of virus signature database 4054 (20090505) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
jeannette0373 said:
I have 1 table (loan information)in a report and one sub-report using one
table (transaction history). When I run the report, the information in the
sub-report is screw, for example, I have client 1234 showing the transactions
for client 2345. I tried setting the relationships,but this doesn't make any
difference. I am kind of new on this, have Access 2003 and will love to have
some help. Thanks.
Click to expand...

Yes, I have client number and loan number in both Link Child Fields and Lonk
Master Fields, also the source object is set up. But I am still getting
right client with wrong transactions. I notice the first client in the loan
information table shows twice in the report, but it is only once in the loan
information table and it's not in the transaction history table.
 
Back
Top