Quote Originally Posted by OBP
Why does your subform need a Join Query?
Shouldn't the query just be based on the Commissions Table or it's query.
The Join for the subform should be established by the Form's Master/Child links?

Because I'm still learning and I thought I was normalizing the database.

The commission stores an ID, CommissionStructureID, RequestID, and the InvoiceNbr, InvoiceAmt, VendorID, Date it was paid to the vendor. I have nothing connecting it to the Customer. So I joined the Commission Table to the Invoices table with the Invoice amount, and then pulled the Customer information from the CustID in the Invoice Table.