Results 1 to 2 of 2
  1. #1
    imtiaz703 is offline Novice
    Windows Vista Access 2007
    Join Date
    Aug 2010
    Posts
    11

    Keep History of Customers Address.

    I have a table in my database for my customers. Sometime my customers change thier address but I want to keep these changes in other table. How it is possible. Can someone help me. Thx

  2. #2
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Customer address will have to be a separate table so that you can have multiple addresses per customer. You will then have a date or an active flag or something to denote this is the active one. A date start or date end is probably the best method.

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

Similar Threads

  1. Different Prices for diff customers
    By kerrin in forum Access
    Replies: 4
    Last Post: 12-31-2011, 07:50 PM
  2. Add to customers/bookings form
    By Dega in forum Forms
    Replies: 1
    Last Post: 01-25-2010, 02:15 PM
  3. Replies: 1
    Last Post: 10-07-2009, 08:15 AM
  4. Input Mask for an IP Address and Mack Address
    By baksg1995 in forum Access
    Replies: 18
    Last Post: 06-23-2009, 12:33 PM
  5. Help me please w/ combining like customers
    By lsulaurie in forum Queries
    Replies: 2
    Last Post: 06-30-2008, 02:59 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