You will probably have to change the form record sources if you change the table structures.
Maybe this demo will help. I normally use queries for form record sources, but this is just a demo....
(Any control that has a background that is pale yellow is a hidden field.)