Attendance subform with Y/N check boxes

[LBRT]

I have looked through these posts and found several questions that are
closely related to mine - esp.an answer from John Vinson (to a W.D. Welch).

I have an app with tables for kids (ID, name, etc.), teachers (ID, name,
etc.), clubs (ID, description), and rosters (ID, foreign keys to kid,
teacher, clubs). I have another "details" data table collecting dates of
participation for each kid in a "class" (club ID & teacher ID) and a few
other details (minutes of duration, category of activity, etc.). Really
simple app - switchboard with three choices: add records to the details table
one kid at a time with drop-down boxes, look at the records entered already
(a query), and exit the app.

I want to allow users to add student participation dates/details not only
one kid at a time (already working) but also by entering the teacher and
program IDs (foreign keys to the details data table) and then a subform shows
only the kids from that roster. Here is where my limited expertise with
Access breaks down. I want the user to be able to check (Y/N) which kids are
participating, then ***somehow*** records are created that match the details
table record definition. I want to load all the details entered by the
teacher for the "class" as a whole (e.g., date, minutes participating,
teacher and program ID, etc.) into each kid's record with his own ID. Then I
can see how I would append this little table to the larger LSADetail table.

At that ***somehow*** is where I am stuck. I am working in Office XP, but I
have the same app in Access 2007 and would like to use it in both places. I
think I want a query appearing in the subform from the roster table, showing
the kids in that "class" [=teacher+club] but (a) where do the Y/N check boxes
come from/go to(what table?) and (b) after I query again on just the "Y" kids
in that roster, how do I create blank records for these kids and fill them
with the other details -

Any patient advice will be greatly appreciated -

With fingers crossed,

L B Tague

 

[Klatuu]

You could have a button on your form to do this once the data is entered for
all the kids. The button would run an append query that would create the
records.

 

[LBRT]

You could have a button on your form to do this once the data is entered for
all the kids. The button would run an append query that would create the
records.
--

Where I am confused about the check boxes isrelated to kid names with check
boxes - there are no check boxes (i.e., field Y/N) anywhere yet. What table
is it in? I have to "check" individual kids, then select only those
"checked", then I create these records to append to the Details file.

Thanks in advance!

 

[Klatuu]

That is what my response referenced. You append query would have to filter
like the filter for the form or subform where you are checking the boxes and
additionally filter for only records where the box is checked.