Hi, I now have a working booking DB, thanks especially to Philmodjunk for several answers to my problems.
I used to use Numbers for this and had a calendar like the image here, which made it easy to see at a glance the availability.
All I want is a small field for each day with the choice of A (available) O (option) and C (confirmed) and some conditional formatting to change the cell colour. What I do not seem to be able to do is copy a standard field many times without it remaining the same field. So now one changes to blue and they all do.
On the other hand, I have for each booking, the arrival and departure dates and the status (A, O or C). I suppose it is possible to get the calendar boxes to change colour according to the dates and status.
Has anyone got any pointers as to how or if this can be done?
Without you guys I, and many others, would have given up by now.