Results 1 to 3 of 3
  1. #1
    Mwhiterabbbit is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2013
    Posts
    8

    Help with conceptualization

    Hello,



    I am trying to build a database for QA samples. The database is to hold the product code, dates, who tested it, and product count. All that is simple enough but I want to be able to add measurements of the packaged product, such as length and weight. How do I tie in together 70 something measurements of length and weight to the current information?

    I don't know if I should keep the length and weight on the same table or a different one. If they were on the same table I don't know how to record the data accuratly as I can't figure out how to make more than 1 individual products weight and length at a time.

    Here is a list of things I want to record.
    Date/time - date
    SKU - number
    Tester Name - text
    Case Code - text
    Amount of Product in case - number
    Product Length - number
    Product Weight -number

    The form I am going to use has inputs for the conventional entries and then 80 possible entries for length and widths.

    Thank you for your help.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,849
    A good starting point would be working through this tutorial

  3. #3
    Mwhiterabbbit is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2013
    Posts
    8
    Thank you I will look into this.

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

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