Adding people to training class

[Yugidad]

This is probably a fairly basic question but I am having trouble getting this to work. We have a monthly training class and a ever growing list of individuals that participate in the classes. An individual may attend one class or they may attend multiple classes. New people are added to the pool of individual that may attend on an ongoing basis.

Once I get the rsvp for a class I want to be able to put out a list before the class and then track comments about the class after it is completed.

I have the following Tables

Participants: which has participantID, first name, last name, and photo

Classes: which has class ID, Class name, class date

Class Details: which has class detail ID, class ID, participant ID, attending (yes/no), comments

I can build a form for the class with a sub form for the class details but since no one is enrolled in the class the sub form is blank.

I would like the sub form to have a drop down where I can select the participant and then check the attending check box

Thank you in advance for your assistance

 

[mahenkj2]

Have you defined relationships?

when you create a form and then select two tables with relationship , then the form wizard itself offers which table you would like to see in the form and the other table in subform.

 

[Yugidad]

Yes the three tables have defined relationships. The sub form is tied to the form based on the ClassID. The subform comes up with no data as no one is attending the class so I am not able to build the class list using the form.

In the Participant table: participant ID has a one to many relationship with Participant ID in the Class Detail Table

In the Class Table: class ID has a one to many relationship with class ID in the Class detail table.

 

[Sketchin]

Create the subform on its own using Class details as the record source and then drag it into the main form in design view. Then create a combo based on the Participant ID.