Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2009
    Posts
    3

    Unanswered: Double Booking Checking

    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

  2. #2
    Join Date
    Apr 2009
    Posts
    2
    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

  3. #3
    Join Date
    Apr 2009
    Posts
    2
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •