auto field update

[kirkland]

Hello

Im creating a booking system to book seminars, lectures etc however am having
alittle trouble...

At present, i have a table called 'seminars' that is made up of the
Title_of_Seminar, date, time and room. I'd like to create a form in order to
book a seminar by having a combo box on the form that displays all the
seminars that my company has to offer. By clicking on the seminar the user
wishes to book, i'd like the next box on the form (which is the date box) to
display only the dates that, that seminar is on. Once the date has been
chosen, the time box should automatically display only the times that the
chosen seminar is on at. Once all three entries have been chosen, i'd like
the user to make a booking on the same form without using a subform for
booking but am not sure if this can be done?

I know these types of questions are asked frequently so i apologise in
advance if i've missed the reply on another thread, hence have started this
one

 

[Guest]

I just answered an almost identical question. Look at the post in this group
with the heading "Dependend Combos".

Now, in your case, your table structure needs to be redone. The table as
you have described needs to be broken into at least 2 tables. The frst table
should be only information about a Seminar. It should not include date,
time, room, instrutor, or any of those things. It should contain the Name,
prerequistes if there are any, duration if it is always the same, and fee.
This should be your Seminar table.

You need a SeminarSchedule table. It will contain Which seminar, Date,
Time, Location, Instructure, Max Attendees allowed.

You also need an Attendee table. This will be info on everyone who attends
any seminar. Since an Attendee may attend one or more seminar, this needs to
be its own table.

Since one or more attendee may attend one or more seminars. you need a
Seminar Session table table that will contain who attened which occurance of
which seminar.