Richard, I just downloaded the PCResale Database for this lesson (Expert 23). I was doing some exploring and trying to add products to OrderF. When I try to create a new order in this database for an existing customer via the Add Product button at the bottom of OrderF--the button is actually part of subform OrderDetailF, at the bottom--I get the following error when I try to tab to the second product: "You cannot add or change a record because a related record is required in table 'OrderT'. I thought we fixed this issue in previous lessons. (Was it Expert 22? I don't recall.) Why's it still in Expert23? I must be missing something. Thoughts?
Kent JamisonOP
@Reply 4 years ago
Scott Axton
@Reply 4 years ago
Kent if you watch Access Expert 22 Lesson 3 at about 16:45 Richard says "remember you have to remember to change the parent record..." He indicated he would show how to fix that when he got to the macros.
Fast forward to the Access Advanced 2 in Lesson 2 he finally got around to showing how to fix that problem.
Kent JamisonOP
@Reply 4 years ago
Thanks Scott. I completely missed that reference at 16:45 in Expert 22, Lesson 3. I'm tracking now.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 23.
