While I've come to really like our new reporting tool FastReports, there are a few things that took some creativity to figure out. One of those things were "Many to Many" - or m:n - relations. Here's how it's done.

Background

A typical example would be a list of orders. On one side you've got an "Order" table with general information like customer, date, etc. On the other side you've got your "Products" table with item name, cost per unit, etc. And in between there is your "OrderPositions" table that puts the products into the orders.