Automated Table Entry/Deletion 1

[fused13]

I have a problem with a Database I am currently working on.

The database records information regarding room availability.

ie Customer B books Room 1 between Monday and Friday,this information needs to be checked for availability for the days required. So if customer A, who has already booked Room 1 for Tuesday and Wednesday but then has to cancel, the room then becomes available.

How do I incorporate this feature into Access?

 

[MichaelRed]

This IS going to get U G L Y (as if my post isn't ALREADY!!!).

First, ALL processing needs to be dont strictly through forms. Ms. Access doesn't have any record operation triggers, so the Form events are the only way to 'capture' changes to the underlying dataset(s).

Second, I'm asuming that you can ALREADY do the checking for the contigious availability of the resource (e.g. ROOM 1). If not, stop here - because the remainder will just be so much gibberish.

Thrid. You need to book [requests] and [reservations] seperatly. [Reservations] are the 'granted' requests. In the [Requests], you need a field (Foregin Key) for the [Reservation] which is Empty (or null) for open [Requests], or have the [Reservation] id.

When a [Reservation] is cancelled (or a [Request] is entered, have the system check all open [Requests] (in your order of priority) to see if any OPEN requests can be filled.

Only 1.e^6 details left for the student (I SAID it would get U G L Y)!!!!!! MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over