var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Double Booking Checking
Firstly I'm new to filemaker and i'm attempting a booking system.
So far i have a few tables:
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.
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