Updating Junction Table - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Updating Junction Table

Quintin Polly

5 years ago

Good afternoon:
I have a many to many relationship in my Internal Control Task Monitoring Database. Currently, I have a Risk Table and a Control Table that are joined by a RisksControls Table. I have created a Risk form that has the associated controls displayed in a nested continuous subform. I am able to add risks and controls through this form. When added the Risk and Control tables update with the new records. However, the RisksContorls junction table does not update. How can I get the junction table to update?

	Alex Hedley @Reply 5 years ago
Might be worth watching Enrollment Tech Help

	Quintin Polly OP @Reply 5 years ago
I appreciate your suggestion, but I was not able to find what I was looking for in that video.

	Scott Axton @Reply 5 years ago

	Scott Axton @Reply 5 years ago
Go to the properties of the subform. Make sure that the link fields are correct for your Form and Subform.

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

Next Unseen

New Feature: Comment Live View