helenp - 4:16 pm on Jun 21, 2008 (gmt 0)

I have something similar, I have properties with availability.
I have one table for all the properties with all their prices in datefield though there are diferent prices for diferent months, this table I need to update and change the year, and in another table I insert the bookings in 2 fields, one for arrival and one for departure, and based on that I get the availability, this way you dont have to redo the table availability every year.
But it was very dificult to do the availability for the web, I had help with that in this forum.