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

1.create the RoomId as foreign key in Customer table using this relation u can create the realtionship between customer & room
then through that relation pick the checkin & Checkout time

2.For Not alloting the same room to other customer table check in the customer table whether that foreign key Room Id exist or not if it exist then room has been alloted else its is free

create one more field in customer table status which will contain two values only Left / Availableby checking the status & roomId u can find whether the roomis vacant or full