Studnet Attendance Form? Cant get editalbe check boxes

[ldXbl]

I work at a school and we are trying to develop a way for an instructor to enter attendance directly into a access form. We have 2 tables that relate to this problem

tblClients
------------------------
SocialSecurityNumber ---PK
FirstName
LastName
InstructorID ---FK to tblInstructors
Active true/false

tblClientAttendance
---------------------------
AttendanceID --PK AutoNumber
CientID --FK to tblClients
AttDate
AMPresent
PMPresent

I tried to use a left join off a query
Query1:
SELECT DISTINCT tblClientAttendance.ClientID, tblClientAttendance.PMPresent, tblClientAttendance.AMPresent
FROM tblClientAttendance
WHERE ((([tblClientAttendance].[AttDate])=Date()));

Query2:
SELECT tblClients.FirstName, tblClients.LastName, Query1.PMPresent, Query1.AMPresent
FROM tblClients LEFT JOIN Query1 ON tblClients.SocialSecurityNumber = Query1.ClientID
WHERE (((Query1.ClientID) Is Null));

This gave me the data i neeeded but it was in an noneditable form. I have tried many other ways but with no luck. I have seen a attendance form like this at another school years back so i know it is possible. I just need to be pointed into the right direction.

Thanks from all of the Staff at the Red Apple School

http://www.redappleschool.org

 

[ArtistRhetta]

You will probably have to have a primary key in each table and then create a relationship to the tables and join it at the primary keys. After you do that, create your form and see what happens.

 

[jrbarnett]

Create a form based on tblClients, and another form based on tblClientAttendance. You then insert a subform on the form that has tblClients and point it to the tblClientAttendance form, and link the two on the ClientID/SocialSecurityNumber field.

John

 

[ldXbl]

Thanks for the quick response.

Let me see if i understand things correctly jrbarnett if i use a sub form am i correct that an instructor will have to use the record navigation buttons to go through the students in their class? I have tried that but i need an interface that is simple. like a list of all active students with a checkbox for present in a datasheet view.that way it is one form and the instructor can just go down the list and check the students off.

ArtistRhetta If i do the join at the primary keys how do i get the needed info into the one table? could you please explain more? i need the datasheet view with the students name and a checkbox for the instructor can mark present.

Thanks both of you for all your help....