I'll start off by saying that this is for a class so I'm working with instructions. We are working on a Custom Form in Design View, frmTireOrders, which has a ComboBox at the top containing the CustID. In the last step they had us create a Query, qryInvoiceTotal.
In this step they want us to ad a subform but based on the qryInvoiceTotal and include all the fields but when I go to click "Next" after selecting "Show qryInvoiceTotal for each record in the tblCustomer using the CustID" I get an error message saying - "The link you selected can't be used. This link was created based on relationships between source tables.To use this link, you must go back to the previous page and include the missing fields."
The only relationships we have in this database are a one-to-many between the tblCustomer to the tblSales with the CustID and a one-to-many from the tblTires to the tblSales with the PartID.
I saw someone ask elsewhere for a copy of the database, so let me try to include that now. Nope, the file size exceeds the Forum Limits. I went back, made a copy and cut out all but the 3 Tables, the Query, and the Form but after Compact & Repair a couple times it's still 36kb too big