use one form to add data to two related tables

[workingpoor]

I need help. I am not sure if this is a form issue or a logic issue i have a db for tracking students the classes they take and their notetakers for classes. Each class is most likely unique to each student but sometime there are multiple students in each class that need a notetaker and there should only be one notetaker per class. I have 3 tables and they are all linked through a unique iD called CRN (number).

I am looking for a way to add a student to a class and create a class at the same time in one form. I am trying to limit the redunancy by adding a class each time and then adding a student to the class.

Any suggestions would be great. I have gone through 10+ redesign and am just at a loss on how to accomplish this.

 

[Banana]

Without more details, I can't give specific instructions, but at least I can tell you there's at least three ways to skin a cat.

1) You can create a query that pulls together all 3 tables and base your form on that query.

2) You can use subform to hold the class or student data.

3) You can use open recordset and VBA to insert/create a new record.

HTH.