Stil need help!! Reduce # of available in seperate table with form.

[Vol]

I have a data entry screen for hotel reservations. (Linked to [Reservations] table). Also a table in which room allotment is entered. Say I have 20 suites available at "X" hotel for November 3rd, 4th and 5th. I need to enter the new reservation for those days and reduce the number in the allotment table to 19 for each day.

Also, what would be the best way to link the two?

Allotment table
[Hotel]
[RoomType]
[Date]
[#_of_Rooms]

Reservations table
[Hotel]
[RoomType]
ArriveDate
[#_of_Nights]
[DepartDate]

Thanks!!;-) [sig]<p>C. Szymanski<br><a href=mailto:V0lup2us@aol.com>V0lup2us@aol.com</a><br>[/sig]