I'm not sure the best way to go about this. I have attached a document showing the relationships of my tables. I need to build a form to update the tblReviewHistory table and the tblBranchReviewHistory. On the form, the user should be able to select the client and then input the dates for the review. Then if the client has multiple branch locations, the user can select which locations were visited for that review. Please let me know if more information is needed. Any suggestions are appreciated. Thanks!