Error Related Record - Microsoft Access Expert 4


	Back to Access Expert 4 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Error Related Record

Joel Burroughs

6 years ago

Hi Richard,

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.

Richard Rost @Reply

6 years ago

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.

	Richard Rost @Reply 6 years ago
I accidentally moved your post to the wrong forum. This email should point you in the right direction. Sorry for the confusion.

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

Next Unseen

New Feature: Comment Live View