Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2009

    Unanswered: Need Help With Tables and Relationships

    I am racking my brain trying to figure out how to set this up correctly. I am fairly new to access 2007 but I understand the basics.
    I am trying to setup a database that will track every time a property has a price adjustment. So I created another table called “price” with the following fields:

    Original List Price
    Current List Price
    Date of Price Reduction

    Every time a property has an adjustment on price I want to keep track of it (accumulate all price changes for that property). The way that it is set up now it that every time I make a change to the record it changes the price in the database and doesn’t keep track of the price reductions.
    How do I create a relationship that will do this correctly so that I can entry it while in the form?

    I’ve attached a copy of my database file zipped and a jpg of my tables. I know this is simple but I can’t seem to find out how to do this.
    Also can anyone recommend any good sites with video tutorials? Reading doesn’t work well for me, I need visuals.
    Attached Thumbnails Attached Thumbnails Untitled-1.jpg  
    Attached Files Attached Files

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 15
    You need to add a foreing key [TransactionID] to the Price table and create a relationship between The Price and Transaction tables based on that key. You could also remove the [Original List Price], [Current Price] and [Date of Price Reduction] from the Transaction table. If you want to further normalize [Original Price] is not necessary in the Price table : [Original Price] is the first chronological entry for a given transaction in the Price table.

    Have a nice day!

    Have a nice day!

Posting Permissions

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