scheduling/rescheduling app

[pnmng49]

I need to develop an Access 2003 App that can handle the scheduling of clients into training sessions (only either AM or PM).
For example:
Company. date session location
ABC Corp 1/1/08 AM Rm 110
XYZ Co. 1/3/08 PM Rm 599

Location Capacity Initially Reserved(based on 2 per invitee)
Rm 110 50 40
Rm 599 100 80

Each location has a maximum capacity that can vary by location (room #). The initial assumption for the number of attendees by each company is two (2). I would hold back a few seats at each session to accommodate requests for seats and additional seats might become available if a company only sends 1 individual instead of 2. The company can verify its plan to attend and provide the number of attendees either by phone or mail.

Each Co. should have the option to schedule into a different date/session/location IF that date/session/location has seats available.

I would like to be able to add new info about new date/session/location and capacities from an input screen for dates in the following month.

Can anyone help me get started on this??

 

[The_Doc_Man]

The "Search" function near the top of the topic-list pages works really well, or you can look at the article published last week about Google searches.

Look for topics "Scheduling" and "Booking" - but you have to watch for the scheduling threads more carefully. Some of them will be "task scheduling" rather than "people scheduling" or "room scheduling." This topic has been addressed many times.