linking 3 tables problem

[WaelYassin]

Hi all, i am using CR 9 and MS access database.
i have 3 tables tb1, tb2, tb3 .
the linkage is in the same order.
the problem is that there is a duplicates in the middle table (tb2), which in turn make duplicates in the whole report.
how can i treat that problem of duplicates where the solution of removing the duplicatesin the middle table is not possible.

 

[Madawc]

You first need to group, on some value like account numberin the middle table. Insert > Group and choose a field.

Note that it has to be some property of an individual 'row', a detail line derived from a single record, or from several individual records from different tables (datasets).

You can then move the record details to group header or footer, and suppress the detail line. (Right-click on the section and choose Format Section.)

If the records are not all identical, you can choose Report > Record Sort Expert to put them into a particular order.

All of this is based on Crystal 10, but should be OK for Crystal 9.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10