Results 1 to 2 of 2
  1. #1
    pelicanbuyer is offline Novice
    Windows XP Access 2007
    Join Date
    May 2013

    Booking system form

    I am trying to create a party booking system.

    I have a table for customer details and a table for requirements on a party that they book.

    I can obviously create one form to input data in to both tables but I am not sure how to show which party belongs to which customer.

    Can anyone shed some light?

    I realise I can have a Customer ID in both tables and link them but I am not sure how to write to both tables from the form or to have a button that does that for me when I click to book a party, assuming that is the best way?

    (Not all customers book parties)
    Last edited by pelicanbuyer; 05-11-2013 at 03:34 AM. Reason: Additional Info

  2. #2
    alansidman's Avatar
    alansidman is offline Life @ 7100'
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2010
    Steamboat Springs
    Use a subform for the reservations. Look at this video for an idea on how to do it.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. prevent double booking!! help!
    By Jean-Daniel in forum Access
    Replies: 5
    Last Post: 05-16-2012, 06:09 AM
  2. Counting Occupants on a Booking Form
    By bellevue in forum Database Design
    Replies: 12
    Last Post: 04-11-2012, 07:44 AM
  3. Help with making airport booking system
    By matthewjones108 in forum Access
    Replies: 3
    Last Post: 03-13-2012, 08:10 AM
  4. Appointment Booking Database
    By richie2837 in forum Access
    Replies: 1
    Last Post: 07-16-2011, 01:39 AM
  5. booking in form
    By yoma in forum Forms
    Replies: 1
    Last Post: 07-31-2009, 05:40 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums - Senior Forums