Order Totals Not Showing - Microsoft Access Expert 6


	Back to Access Expert 6 Comments List

Order Totals Not Showing

Austin Ritner

6 years ago

I'm going back to this lesson because I think I messed up before.

I'm putting in orders with customers attached, but the AmountDue is not showing up on the OrderT.

I think I messed up the relationship with the two tables.

Currently in the relationship window, I have a one-to-many (type 1 with ref. integrity) between the two tables.

In the CollectionLetterQ, I have a one-to-many (type 2) from CustomerT to OrderT.

Not sure why the order totals aren't showing up anymore.

	Richard Rost @Reply 6 years ago
I'd really need to see your database to tell you what's wrong. Impossible to tell from that little info. Sorry.

	Austin Ritner OP @Reply 6 years ago
I totally forgot that we broke that report earlier..... I was still getting the AmountDue from the OrderT. Ugh. Got it! Haha

	Richard Rost @Reply 6 years ago
OK. Good. See, that's the problem with trying to answer questions for lessons I recorded 7 years ago. I forgot that too. LOL. I should tell people "wait until you finish the entire class before you ask questions." A lot of the times I break stuff so I can show the way to fix them later.

	Austin Ritner OP @Reply 6 years ago
Right lol. And I normally do finish the entire class, but I hadn't used the "Collection Letter" form since I made it, and I only just recently added a "Due Date" field for that to be applicable.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Expert 6.

Next Unseen