Linking tables using form and subform

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Anthporter - 07 Mar 2007 00:42 GMT

I have a database for use in a martial arts school for registration, and have
created a table (Members) for parent information and (Students) for student
information. Member ID is the primary key in Members and Student ID in
Students.

The Members table is linked to Students table by Member ID on a one to many
basis, and I have created a form to enter Member information with a button to
open subform for student data, but my problem is that when I enter student
data the Member ID is not linking, so I get a Member record and a Student
record, but the student record has a blank Member ID field.

How can I link these so that the auto number from the Member ID field in
Members is automatically added to the Member ID field in Students?

Reply to this Message

Damian S - 07 Mar 2007 01:09 GMT

Hi Anthporter,

You want to have your subform actually embedded in your main form, then set
the Link Child Field/Link Master Field properties, and Access will handle the
linking for you!!

Damian.

> I have a database for use in a martial arts school for registration, and have
> created a table (Members) for parent information and (Students) for student
[quoted text clipped - 9 lines]
> How can I link these so that the auto number from the Member ID field in
> Members is automatically added to the Member ID field in Students?

Reply to this Message