Re: Attendance database ?relationship problems

Depending on the number of registrations per event, I would try create two
list boxes on the event form. The first would allow you to select a single
EventsLocation record. The second list box would be multi-select of the
Attendees registered for the Event. Users could select an event and multiple
attendees then click a button to append records to the Attendence table.

You could add other functionality to display current attendees or just show
them in a subform linked to the event and the selected EventsLocation.

--
Duane Hookom
MS Access MVP

"Phil" <Phil@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:451455E5-BCCD-4C9C-94BD-09E6F4A4DB5B@xxxxxxxxxxxxxxxx
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



.