I have 4 tables that contain Names, Addresses, Address Codes, and Contact ID/Address ID. I have attached a pdf below to show the relationship:
This issue I'm having is I want a form that contains the contacts name as well as their address. I figure I would use a bound form on contact names and a subform bound to addresses. I've tried linking through parent/child relationships but I can't get the addresses to show when i update the main form. Additionally I'd like to update the addresses in the form and have it update the respective tables. Any thoughts on how you would do it?