I have a relational database that has 3 tables. The tables are as follows:
The primary keys of the tables are QID, RID, and FID. QID in tables 2 and 3 is a foreign key to participate in the relationship with table 1.
I need to produce a report that shows, for each quotation: All the repairs and fitments that were done using vb code. I don't want to use the Data Environment/Designer to produce the report. The report should show the Quotation details followed by a grouped list of all repairs and a grouped list of all fitments, all on one page. It should compute the sum of all repairs and all fitments and put the total at the bottom of the report.