Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2007
    Posts
    15

    Unanswered: Relationship problems - IDEAS NEEDED!!

    Ive started a onlie store database for a project. The features id like to include are:

    1) Order tracking

    2) When an order is placed I want to relavent stock levels to reduce

    3) When an order is placed I want "purchaed items" field to increment by each
    order.

    I've included the db in Access 2000 format
    Attached Files Attached Files

  2. #2
    Join Date
    Mar 2007
    Posts
    277
    IMHO, both items 2 and 3 are dynamic numbers that should be calculated when needed. Inventory Control: Quantity on Hand
    RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP, ac07, ac10 - WinXP Pro, Win7 Pro
    Please reply to this forum so all may learn.

  3. #3
    Join Date
    Nov 2007
    Posts
    15
    Thanks thats a great help. Still trying to get all the relationships sorted though

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    What have you done so far?
    What have you defined as your entities and how, in simple english, do things go together?

    E.g. entities: customer & order
    one customer can have many orders
    one order can only be for one customer.
    George
    Home | Blog

  5. #5
    Join Date
    Nov 2007
    Posts
    15
    Just working on that right now. I will post db on here in half an hour

  6. #6
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    I advise you post a screenshot or a word document instead of your db. We're simply concentrating on design at the moment (and if we're talking design we're not playing with a database yet )

    In fact, just tell us in words what you've got so far.
    George
    Home | Blog

  7. #7
    Join Date
    Nov 2007
    Posts
    15
    I've completed the Relationships and put the into a word doc

    Thanks for the help!!

    1) Should I create a seperate table for Usernames & Passwords?

    2) Should I make the CD, DVD & Games table in a single table?
    Attached Files Attached Files
    Last edited by mikebyrne; 11-06-07 at 14:32.

Posting Permissions

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