Results 1 to 2 of 2
  1. 04-21-2016, 05:05 AM #1
    JackieFeng
    JackieFeng is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Mar 2016
    Posts
    24

    How to link booking history table

    I have three tables: customer, current booking and booking history.



    which table should I link to booking history table?

    customer and current booking is one to many
    Reply With Quote Reply With Quote
  2. 04-21-2016, 05:18 AM #2
    CJ_London
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,430
    depends on what you want to do but probably customer - but why have separate tables for current and history anyway?
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. VBA - Change date but keep history in another table
    By zipaway in forum Forms
    Replies: 2
    Last Post: 07-22-2014, 09:30 AM
  2. I want to add record history to Table by command button
    By zugapy in forum Forms
    Replies: 4
    Last Post: 03-15-2014, 08:47 PM
  3. New booking but storing table ID via temp var
    By Ruegen in forum Forms
    Replies: 7
    Last Post: 08-09-2013, 12:04 AM
  4. History Table
    By Opid in forum Access
    Replies: 2
    Last Post: 05-07-2012, 10:50 AM
  5. Write record details to another table as history
    By Thomman in forum Access
    Replies: 3
    Last Post: 02-01-2011, 07:15 AM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums