I'm getting the following message when I get to just shy of the 5 minute mark in the 2nd video, Expert 4.
"You cannot add or change a record because a related record is required in table CustomerT"
I went back through the first video and double checked the relationship between CustomerT and CustomerExtenededT and it looks fine. 1 to 1 and same options checked for referential integrity and cascade delete.
I'm stumped. Tried adding a CustomerExtendedID and makeing it the Primary Key in the CustomerExtendedT, but it didn't help.
If this were a VBA class I would tell you to check your spelling. You spelled "Extended" and "makeing" wrong. As you've seen in my videos, I can be horrible with spelling field names correctly too. However, this isn't VBA so you're not typing anything in.
The only thing I can really suggest without looking at your database is make sure the record in your CustomerT is SAVED to the table first before you try putting data in the ExtendedT. If it's still dirty (the pencil shows in the record selector bar) then it's not full committed to the table yet. I believe I mention this in the video. If not, let me know.
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 4.
