Question Multiple Tables in Reports (1 Viewer)

[Harry Taylor]

Please help.

I have a DB with 3 tables;
1) Customer details (address, phone etc)
2) Equipment they have
3) Service History

So that I can print a report showing all of the above on a A4 form I have a simple query which filters using a tick box (on Customer Details).

This works well unless I tick 2 box's. I then customer details, equipment & Service History get jumbled up and isn't record specific.

Any Ideas?

 

[JHB]

Have you drawn the relationship between the tables?
Show what you have and where you have it!
Tick box, filters, query etc.

 

[Harry Taylor]

Hi JBH,

Yes the tables all have a relationship using an account number.

The Equipment & Service history tables have Duplicates and the Customer Details has No Duplicates.

I have a tick box on the Customer Details table , a query (to show the ticked records) and a report which prints the ticked records.

The Problem;
If I tick a box and run the print it shows the customer details, equipment & service history, great.
If I tick 2 box's I get 2 prints. Each print shows the correct customer details, BUT each print shows the Heater List and service history for both records.

I hope this makes sense.
Thanks

 

[JHB]

Show the query string, and a print screen of your report.
Or even better post you database with some sample data, zip it + report name in which you have the problem.