I have an Access 2007 database that has a form on it (e.g. Instructor). Instructors have certifications associated with them. These certifications are standard and stored in another table in the database, so there is a 1 --> M relationship between Instructor and Certifications.
When I am entering instructor records through the Instructor form, I want to enter / show the certifications associated with that instructor. I wish to have these certifications shown as a table on the Instructor form at the bottom.
Can someone tell me how to set this up please?