Re: Events with workshops

Phil

It sounds like you are saying one Event can have zero, one, or many
Workshops, and that Attendees are registering for Workshops rather than
Events.

If you add a Workshop table, then use WorkshopID in your trelRegistration
table, would that do it?

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Phil" <Phil@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:254525FD-94AA-4369-ABD0-190263210822@xxxxxxxxxxxxxxxx
I have an events database that I now need to add workshops, the basic
structure of the tables is

Events:
---------
EventID

Attendee:
-------------
AttendeeID

Registration:
--------------
RegistrationID
EventID
AttendeeId

the real world situation is that some events we run have workshops,
normally
the group will split into smaller groups and attend one of the sessions

e.g.
Bereavment
MCA
Cancer

Each event may have more than one workshop in a day, one workshop or none
at
all. I have no idea how to design the table structure, do I need seperate
tables for Workshops, sessions. Any advice would be greatly accepted. If
you need any more info let me know

Thanks

Phil


.

Relevant Pages

  • =?ISO-8859-1?Q?Irish_Music_Weekend=2C_St=2ELouis_Tion=F3l=2C__April_4=2C_5=2C_?= =?ISO-8
    ...   All instruments and skill levels are welcome! ... Here's a list of the workshops and teachers. ... afternoon workshop sessions with a lunch break in between. ... out around the grounds a bit too, and some play in the gazebo or the ...
    (rec.music.makers.guitar.acoustic)
  • Re: International QL & Mac are 25 event will b e hosted in Lucerne, Switzerland on Sat/Sun Oct 3
    ... with agenda, sessions, exhibition list and FAQ. ... 32 beautiful places (mount Pilatus, famous KKL concert hall, lake ... Sessions and workshops will cover past, ...
    (comp.sys.sinclair)
  • Re: Events with workshops
    ... Thanks for your reply, you have it correct with the workshops, although the ... Lung cancer ... and that Attendees are registering for Workshops rather than ... tables for Workshops, sessions. ...
    (microsoft.public.access.tablesdbdesign)
  • IT Security World 2005 ???
    ... Has anyone been to to the IT Security World 2005 < ... How good are the sessions ... I have been to some workshops in the past ... but informed dictatorship is better. ...
    (Security-Basics)
  • Re: Transfer data between sub forms
    ... create the entries in the Attendees table. ... would focus on the Workshops form with a subform for attendees, ... make table query between Peolpe and Workshops each time I want to extract ... "Personal Details" form shows the data in the Personal Details Table ...
    (microsoft.public.access.forms)