Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2009
    Posts
    8

    Unanswered: Help on making a dynamic table / (need some ideas on the logic part)

    Hi there,

    I am currently working on a database to keep track all of the purchase orders we issue. Right now I am facing a problem. I have a framework for the database done but the problem being that the amount of items on the purchase order can vary. It can vary from 3 items up to 80 items.

    I would like to keep each purchase order as one record but the form I have made (which fits on a letter page nicely) is only capable of recording 22 items. Also, I know the way I set it up is not very flexible because I have 22 Items * 4 fields for each item (Unit price, total price, description, quantity) = 88 fields whenever a new purchase order is made.

    I would like to hear you experts on how to make this database more dynamic since the number of items do change from PO to PO.

    Thank you very much for taking your time to answer my question.
    -Jim

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    You should have 4 fields. No more. That would relate to your one record in your PO table...

    As Teddy so eloquently suggested, you need to go and study the fundamentals of database relationships and you'll answer many questions and save yourself a LOT of trouble down the road.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Sep 2009
    Posts
    8
    Thank you for the replies. I think I know what to do. I have reworked my entire framework with the new structure.

Posting Permissions

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