Reducing # of available in another table...

[Vol]

I need to reduce the number of available hotel rooms per night in our allotment table.

My reservation entry form is basically set up:
[ArriveDate]+[Nights]=[DepartDate]

How should I link it to the allotment table and then deduct from the available nights once the each date is entered? [sig][/sig]

 

[DougP]

If a person arrives Friday and stays 5 nights then they leaves Wednesday morning then Fri, Sat, Sun, Mon, and Tue nights are not available right. And his or her room number can not be given out either.

How is your &quot;allotment table&quot; set up? What is the Key field and what are the other fields in it. [sig]<p>DougP, MCP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.[/sig]

 

[Vol]

Yes, that is correct.
I actually have 3 keys for this table:

[Hotel], [RoomType], [Date]

The others are...
[Units]-#available rooms for the specified date.
[DaysOut]-Days until allotment amount runs out.
[LastCancel]-Hours before midnight of arrival day when you are charged for no show.

If you can make some suggestions if it should be set up differently to make my life easier, that'd be just swell!
Thanks,
Vol s-)
[sig][/sig]