85 Order Referential Inegrity - Microsoft Access Expert 8


	Back to Access Expert 8 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

85 Order Referential Inegrity

Monica Jones

3 years ago

I'm on lesson 5 and I have the customer/order one-to-many with referential integrity relationship created no worries. The issue happens when I go to create the order/order detail relation. I can make a one-to-one relation no problem, but when I click on "Enforce Referential Integrity" I'm no longer able to click on "Create". I can go to "Create New.." and get the "Edit Relationships" window to say it's one-to-many, but when I click on "Create", it displays as a one-to-one and I still can't add "Enforce Referential Integrity". I'll add a picture below.

	Monica Jones OP @Reply 3 years ago

	Scott Axton @Reply 3 years ago

	Scott Axton @Reply 3 years ago
Change the JOIN. Right click the line and make it 1 to many as well. That should fix your issue.

	Monica Jones OP @Reply 3 years ago
I tried that before and when I clicked "Create" nothing happened. Just tried again and it worked. I think maybe I had OrderT, or something related to it open.

	Scott Axton @Reply 3 years ago
Just to confirm though - It's working now?

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

Next Unseen

New Feature: Comment Live View