Report with one subreport

[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.

 

[Larry Linson]

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

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

__________ 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]

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.

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.