Hello,

Firstly I'm new to filemaker and i'm attempting a booking system.

So far i have a few tables:

CustomerID
FirstName
LastName
CheckIn
CheckOut
RoomID
Serial#


RoomID
RoomID
RoomNum
BedNum
RoomType
Rate
Serial#
DateRange

I want to be able to pick a checkin and checkout date for a particular room and somehow stop double bookings for the same room in the same period of time.

I'm volunteering in a Dharma Centre in India and this is my task at the moment, to create a booking system...

Hope someone can help or atleast offer helpful advice/point me in the right direction.

Regards

J