Limit number of records created in a table

[MrTickle]

Hi

I am developing a database for booking hotels for individuals and groups. I have come up against a problem for part of it. I have 2 tables; 'Bookings' and 'Reservations'

'Bookings' holds information about the client, the hotel they are booking, arrival date and number of rooms booked amongst other things.

'Reservations' holds details about individual guests, room type, rate etc.

The two are linked by a booking reference.

The user inserts the amount of rooms booked into the 'Bookings' table. I want to limit the amount of reservations that can be made against the booking reference in the 'Reservations' table to the amount in the 'Bookings' table. I also want to record how many rooms are left to be filled so that this might be searched upon via a query later in case names are not provided at the time of booking.

How can I best achieve this?

I have no programming ability, I am new to Access, so if anyone can suggest some useful reading on the relevant knowledge I will need in this area I would be most grateful.

Thanks for your time.

MrTickle

 

[jdraw]

in my view, you don't have enough tables to do reservations...

here is a fee data model
http://www.databaseanswers.org/data_models/hotels/hotel_reservations_physical.htm

 

[MrTickle]

Thanks for the reply. I have other tables too, very similar to the model you show here, but that will be useful for comparison. I only refer to the 2 tables in this thread because it is the specific issue I am trying to resolve.

If anyone can offer any further guidance I'd be very grateful.