Help Design a Training DB

[Wolfgang]

Hi,

I was wondering if anyone could give me a pointer or two on how to design a Training DB.

I have done the following:

Created table with list of venues, captured trainers where they live (or train) etc, what I am stuck with now is how to create a new table that links the venue to the Trainer.

I have played with a test table that links the Venue to the trainer, but if the event is 3 days long and this trainer can only train one of the days I am stuck, and another thing is I must create all 3 days manually. I tried to use DAO to create the dates automatically. I would like to be able to be able to automate this as much as possible.

I have thought about using sub ID’s for the event, ie all the days in one training course must have the as sub ID, but how do I remember the last sub ID used?

We would also like to send out e-mail’s to all the trainers in a city and based on the response show their availability for a specific course or event.

Any help will be appreciated.


Wolfgang

 

[glynch]

In the event table, have fields for the start date and end date of the event. Then in the table that trainer-at-event table, have fields for the trainer's start and end dates at the event. You should be able to use these four date values to create a schedule of which trainers will be present on which days.

I am assuming that the trainer/event relationship is many to many and this trainer-at-event table will hold one record for every instance of a trainer attending an event.

Good luck, HTH