Creating a dynamic form?

[cheftim]

Hello,

I am trying to create my first "major" data base to be used as a reservation and service schedule for conference center and am stumpped.

I would like to be able to enter a starting and ending date for an event, then have multiple records for each day between. I have a query that will calculate how many days there are. The number of days will change with each event.

I need to have information that changes with each date. (i.e. there may be 50 people for lunch on one day and 75 the next and they might use 1 b uilding the first day and 3 on the second.)

I would like to have a form (or sub-form) for the reservation page that would list each date of the stay and then be able to check off the services and other information for that particular date without making our reservation clerk enter each date for the entire stay.

Is there a way to make this happen?

I apologize if I have not frammed this question correctly - being new to database creation I have trouble enough just understanding my own questions - let alone the answers but I appreate any help you can give me in the design of this project.

Thanks in advance,

t

 

[dsigner]

These things are always very difficult at the analysis stage. It seems to me that you may have your focus wrong. The first thing I would create is the facilities availability - there is no point in two events moving into the same space at the same time. Once you have this and can populate it with events (slowly) you will then see how to minimise the input work with a booking form which provides a start time and end time for each facility required. It is then straightforward to write a procedure which transfers the booking to the required slots. You will finally be able to have reports showing your plans by event or by facility. Hope that this helps.