Hi Tc Holzer,

Thanks for your response.

I've figured out how to add multiple datasets to the report and how to change the SQL query on them provided they keep their structure [ where were you yesterday? :) ] but the question about adding multiple database tables to a single table is my main problem now.

For example - three tables: Transaction, TransactionDetail, Stock

Transaction
transID, custRef,

TransactionDetail
detailID, transID_FK, stockID_FK, qty, amount

Stock
stockID, stockRef, stockDesc

The table will display:
transID, stockID, stockDesc, qty, amount