Reports from a query based on linked tables.

[dichotomous]

My report produces multiple copies of the same record. I know why, but don't know how to fix it.

I'll explain from scratch.

EmployeeTable.

With a one to many relationship with TrainingTable (via employee PK as FK in trainingtable).

Training table has a one to many relationship with a table called Range.

Report is based on a query that picks up the Employee/Training/Range (range just describes the training unit).

However, If I have more than one range expressed againsed a training unit, the report spits out several copies of the Employee record to display all the ranges.

How to fix??

many thanks in advance.

 

[plog]

Which of those many records in Range should it use for the report? If you could provide sample data (including table and field names) from the 2 tables and then what you want displayed on the report based on that sample data, it would be helpful.