Attendance designs are generally

Event---(1,M)---Attendance---(M,1)---Person

Then Attendance is something like
EventID, PersonID, Attended (Y/N)

I'm pretty sure there are attendance-type databases all over the place...
I've seen similar questions many times here.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201005/1