Hello, I have a master table, and a detail table. (One master record to many detail records, and an ID number that links them.) I have a form that shows the master record data, with a button that launches a form that shows the detail records for that master record. (Where condition ="[Master ID]=" & [ID]). That much works. My problem is, when I want to add a new detail record on that same open form, how do I get it to only allow the new record to have the same master ID? Currently it allows a new record to contain any master id. Thanks very much.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!