Marking an attendance

[Richard Williamson]

Hi all,
I have tables set up something like:

Member(MEMBER_ID, name, etc)
Event(EVENT_ID, eventname, place, time)
Attendance(MEMBER_ID, EVENT_ID, present)

I am trying to bring up a form which shows an event with a subform
with all the members names displayed, along with the check box for
'present'. However, I cannot get it to show ALL the names. The query
the subform is based on shows all the correct fields, but these don't
show in the subform.

Any help or examples of this would be MUCH appreciated.
Regards
Richard WIlliamson

[Pieter Linden]

ri*****************@ntlworld.com (Richard Williamson) wrote in message news:<62**************************@posting.google. com>...

Hi all,
I have tables set up something like:

Member(MEMBER_ID, name, etc)
Event(EVENT_ID, eventname, place, time)
Attendance(MEMBER_ID, EVENT_ID, present)

I am trying to bring up a form which shows an event with a subform
with all the members names displayed, along with the check box for
'present'. However, I cannot get it to show ALL the names. The query
the subform is based on shows all the correct fields, but these don't
show in the subform.

Any help or examples of this would be MUCH appreciated.
Regards
Richard WIlliamson

So how about basing the subform on a query?

something like...
SELECT A.MemberID, M.MemberName, E.EventID, A.Present
FROM (Member As M INNER JOIN Attendance As A ON M.MemberID=A.MemberID)
INNER JOIN Event As E ON E.EventID=A.EventID)

basically, just join Member to Attendance on MemberID, and Event to
Attendance on EventID, and you're there. Base your subform on that.

[Richard Williamson]

I've done this: the query displays the name and tick box for each
person. However, when this is used in a subform, the rows with no
attendance ticked are not displayed.

Regards
Richard W

So how about basing the subform on a query?

something like...
SELECT A.MemberID, M.MemberName, E.EventID, A.Present
FROM (Member As M INNER JOIN Attendance As A ON M.MemberID=A.MemberID)
INNER JOIN Event As E ON E.EventID=A.EventID)

basically, just join Member to Attendance on MemberID, and Event to
Attendance on EventID, and you're there. Base your subform on that.