G
Guest
I read an excelent article on append queries
(http://office.microsoft.com/en-au/assistance/HA011860631033.aspx) and I want
to use an append query to create records from user choices on a form. The
form has 2 subforms with information from 2 different tables. I want to
create new records in a third table from this form. One subform allows the
user to filter students so that they have the group they want to assign tasks
to. The other subform has the tasks that are to be assigned. The table
containing the tasks is a temporary table that holds just the tasks the user
has picked.
I want to create a record that has the student's ID from the first table and
the task from the second table. I want one record for each student/task
combination. There may be any number of students and up to 3 tasks.
How can I make the append query pick the students that are in the recordset
the user has filtered to make the new records?
-rg
(http://office.microsoft.com/en-au/assistance/HA011860631033.aspx) and I want
to use an append query to create records from user choices on a form. The
form has 2 subforms with information from 2 different tables. I want to
create new records in a third table from this form. One subform allows the
user to filter students so that they have the group they want to assign tasks
to. The other subform has the tasks that are to be assigned. The table
containing the tasks is a temporary table that holds just the tasks the user
has picked.
I want to create a record that has the student's ID from the first table and
the task from the second table. I want one record for each student/task
combination. There may be any number of students and up to 3 tasks.
How can I make the append query pick the students that are in the recordset
the user has filtered to make the new records?
-rg