• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 422
  • Last Modified:

Creating a Table on a Access 2007 form linked to another table in the database

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?

Thanks...Tom
0
tpigielski
Asked:
tpigielski
1 Solution
 
Rey Obrero (Capricorn1)Commented:
create a form with subform, using the table with 1(Instructor) as recordsource of the main form and the table with Many (Certifications) as the recordsource of the subform

set the Master Link field to the instructor ID from the Instructor table
set the Child Link field to the corresponding INstructor ID in the Certifications table

see this demo


Create a form that contains a subdatasheet

http://office.microsoft.com/en-us/access-help/watch-this-create-a-form-that-contains-a-subdatasheet-HA010277407.aspx
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now