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 JonesOP
@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 JonesOP
@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?
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 8.
