I have a many to many relationship between two tables in my framework which I need to retrieve right data. Whenever I run a report a warning window pops up saying there is a many to many relation. How can I avoid this warning message ?? Please Help.
Hi,
The whole point is that a many-to-many relationship is a big problem. It's called a chasm trap. Let me give you an example. If you have a many-to-many relationship between your Suppliers table and your Products table, it means you can't derive which supplier provided a product. You can't derive which product came from a supplier. It's an indication of missing data in your model - you need to resolve it bt adding in to your model the table (or logic) that allows the atomic relationships to be defined.
Can you provide info on what your many-to-many relationship describes?
MF.