Attendance database ?relationship problems

I am attempting to set up an attendance database:

the tables I have are:

Attendees
=======
AttendeeID (PK) 1:n with Registration
1:n with Attendance
Demographic data
e.g firstname, surname etc.

Events
=====
EventID (PK) 1:n with Registration
Eventname
Spaces etc.

Registration
========
RegistrationID(PK)
AttendeeID
EventID
RegFee etc

These three table I think are OK the events database works how I want with
these
table. the remaining tables to add attendence are:

EventsLocation
==========
ID(PK) 1:n with attendance
EventID
DayNo.
Numberofdays
Dateofday
venueam
venuepm

Attendence
========
AttendenceID (PK)
AttendeeID
ID
AttendenceDate
Attended (Y/N)

this is where I am stuck, I would like to have a form open from my events
form, which would have a list of each person on the course with each date and
tick boxes

e.g
12/6/06 13/6/06 14/6/06
Michael Mouse [] [] []

I cannot think of a way to get data into the table, I have tried queries but
when I add the attendance table I get no records back (probably because there
are no records in the table)

I am stuck and need help

hope someone can help

Thanks

Phil

.

Relevant Pages

  • Delete record not cascading through tables
    ... I Have been here a few weeks trying to get a attendance database up and ... attendence records stay in the table. ... and a 1:m relationship but it still does not cascade the deletes. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Attendance Data
    ... I currently have a attendance database created by date, ... have this data, in reports, I want to be able to tabulate and provide a ... able to total out of 100%, a student had 50% attendance. ...
    (microsoft.public.access.gettingstarted)
Loading