Form won't let me add Subform due to Relationship between Source Tables

[RuffianRan]

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

[alansidman]

try to zip the file first.

[RuffianRan]

Access Help.zip I had thought about that but wasn't sure

[RuffianRan]

I don't think any of the other clutter that I cut out is necessary but if you find you're missing something I can zip the original.

[orange]

Not sure we are missing anything. My guess is you could include your entire database (no deleting of objects necessary) if you do a compact and repair and then a zip.

You my get some ideas and insight by reading through this thread related to Orders Products etc.
There are some key concepts.

[RuffianRan]

Here's the whole thing. The assignment is due tonight, I'm trying to search the web for answers but it's not working.

[RuffianRan]

I didn't understand much of what I read on that thread...I'm not really overly literate in code. Not positive I compacted & repaired after my last form label adjustments, hope that didn't matter. Love the cat, btw

[orange]

I looked at your database and form. Is the attached similar to what you are trying to do?

Let me know and give me some info of what you are trying/tried and results.

[RuffianRan]

Yes, but I'm trying to add a subform under the Total of Invoices that includes all the fields in the qryInvoiceTotal Query

[RuffianRan]

In this step they want us to add a subform 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."

[orange]

I was attempting to use the CustomerId combo top right and you qryInvoiceTotal and get a jpg.

I am seeing different totals but same cust First and Last even though I'm selecting a different CustID??

The link I suggested shows and discusses the typical set up of

Customer-->Order---->OrderLineItem<---Product

which is not what you have. So now it's down to some investigation without
a) doing your homework assignment, and
b) not causing you too much diversion.

[RuffianRan]

This was an incorrect post

[orange]

Hang in. Forget the code. It was a thread dealing with a few concepts and a poster who was very hesitant to give info.

What is this course you're doing?
What is the big issue at the moment? The message says you're trying to use something that wasn't included or was not appropriate.
In your own words --simple terms -- what should go on the main form, what should go on the subform, and how would those things be related (in order to keep the subform info in sync with main form)?

[RuffianRan]

It's called Expert Access in Computer Science. I took Access Level 1 last semester in Business Applications. I'm trying to get my MS Office Specialist Certificate and the end goal was to go on to get my Associates in Interactive Media but I'm not so sure about that now.

So my ComboBox isn't working either. I wasn't supposed to add the Calculated Total of Invoices field until after the subform I think. I got the instructions all mixed up. I kept trying to add the InvAmt field to the Subform when I was supposed to add it to the Query. That's how that got there already. Should I delete that field and try again? But still, why isn't my ComboBox working?

[RuffianRan]

Didn't work