The trouble I am having is getting the data to display as I described. Currently I get the two header tables to show correctly but when I try for the Raw Materials I start getting duplicated outputs.

Have you ever tried to do a report as I have described with a total of 5 tables (2 header tables have a 1-1 relationship and 3 detail tables with a 1-many relationship)?

Currently I have only input 14 quotes and only 7 of them did I input the details. In the end we will have around 10,000 quotes and all the corresponding details.

I do need each quote on a single page. I have a specific format I have to duplicate (hence the need for 5 tables on each page as output).

Eventually we will probably set up a filter of some sort to either only output a specific part or output a specific part type, etc.

I have tried using a parameter of QuoteID and it doesn't seem to work properly and I still end up with wrong outputs.

I have tried one big query with all results. I have tried individual queries for each table's data all linked by QuoteID. I have tried sub-reports. I have tried multiple tables and imbedded tables.