Results 1 to 2 of 2
  1. #1
    gtimmies is offline Novice
    Windows Vista Access 2010 64bit
    Join Date
    May 2013
    Posts
    2

    Transaction Log

    Hi,



    I am in the process of designing a database for a car sales company. The company sales cars and also buys cars back from its customers. How should I design my tables so that the database keeps track of each car as well as the sales and buy-backs of the car? (example: a customer purchased a Honda Civic in 2012 and sold the same car back to the company in 2013. I would like the database set up in a way that if I look up the Car ID, I will see the transaction history for the car)

    Thank you for your help

  2. #2
    rzw0wr is offline I will always be a newbie
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Indiana
    Posts
    479
    gtimmies,
    Please see note on the other forum.

    Dale

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

Similar Threads

  1. How to Print current Transaction?
    By cap.zadi in forum Forms
    Replies: 1
    Last Post: 12-08-2011, 07:47 AM
  2. Replies: 7
    Last Post: 11-14-2011, 05:59 PM
  3. Transaction v Lookup table
    By jke in forum Access
    Replies: 2
    Last Post: 06-15-2011, 08:44 PM
  4. SQL Transaction question
    By Mazdaspeed6 in forum Programming
    Replies: 4
    Last Post: 12-16-2010, 12:51 PM
  5. Latest Transaction Report
    By Worm in forum Reports
    Replies: 3
    Last Post: 08-16-2010, 06:10 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
  •  
Other Forums: Microsoft Office Forums