M:M relationship

[Swetal2004]

I am using towo tables with M:M relationship
Therefore it returns multiple duplicate records for a perticular ID of interest.

Is there a way to return unique ID in this situation

 

[kskid]

It would be very helpful to know the following so we can provide the proper answer based on the Crystal version you are using. Based on what you provided, we can only guess on what you need.

Crystal Version
Database
Connectivity
Sample data
Expected output

We know that is a many to many relationship but what are you trying to accomplish? Is your records slection based on some value, date or absentce of a value? There's a myriad of solutions to your problem based on what you have given so far.

 

[Madawc]

If you group by ID, hide the detail lines and just show the group header, that gets rid of duplicates. Is that what you want?

As wichitakid says, you do need to give more details, including Crystal version. Different solutions are available for the different versions.

Madawc Williams (East Anglia, UK)