R
Ripper
I have a problem. I have a table(tblStudents) that conatins a list of
students (Name, LocID, Ethnicity, etc.) I have another table (tblWatch) that
contains a list of student IDs and potential watch groups for them to belong
to (New Students, Last Year Test Failures, At Rick of Failing, etc) as Yes/No
fields. Students can belong to more than 1 group.
tblStudents is the complete list of students in the district and is updated
weekly. All the queries look for the max of upload date to keep only the
current students in the queries.
tblWatch is created a record at a time by administrators as they add kids to
the different groups. This is will not contain all the kids in the district,
only those in watch groups.
What I would like to do is create a form that contains all the students on a
particular campus and then checkboxes for all the potential groups the
studetns could belong to. I created a query and had the join between LocIDs
set to show all records in tblStudents. However, it is not updatable, unless
there is already a record created in tblWatch. How can I create a query/form
like this? I know you'll need more information, just let me know what you
need.
students (Name, LocID, Ethnicity, etc.) I have another table (tblWatch) that
contains a list of student IDs and potential watch groups for them to belong
to (New Students, Last Year Test Failures, At Rick of Failing, etc) as Yes/No
fields. Students can belong to more than 1 group.
tblStudents is the complete list of students in the district and is updated
weekly. All the queries look for the max of upload date to keep only the
current students in the queries.
tblWatch is created a record at a time by administrators as they add kids to
the different groups. This is will not contain all the kids in the district,
only those in watch groups.
What I would like to do is create a form that contains all the students on a
particular campus and then checkboxes for all the potential groups the
studetns could belong to. I created a query and had the join between LocIDs
set to show all records in tblStudents. However, it is not updatable, unless
there is already a record created in tblWatch. How can I create a query/form
like this? I know you'll need more information, just let me know what you
need.