Results 1 to 3 of 3
  1. #1
    twelvedigits is offline Novice
    Windows XP Access 2013
    Join Date
    Jan 2016
    Posts
    1

    Recording multiple values of same type to one record

    I am at the planning stage for a new database which will monitor the quality of work done by staff daily (Assessing applications). There are around 20 error areas in these applications and 3-5 error types for each area.



    I designed a database 2 years ago for the same purpose in the format below:


    Field Data type
    Error Area A Look up error type
    Error Area B Look up error type
    Error Area C Look up error type

    So each error area had its own field which would be set by default to (N/A). This was fine for recording errors, but became very cumbersome for designing dynamic reports.

    Ideally, I would do something like this:
    Field Data Type
    Error Area Look up list of error areas
    Error Type Look list of error types for error area selected above

    The problem is there can be more than one error made in each assessment done. I would like to be able to record multiple values for both fields which are linked to each other, example I want to select the following errors on my form:

    Error Area Error Type
    A A1 (Error type dropdown will list possible areas for error Area A: A1, A2, A3, A4...)
    C C4
    F F5

    Can anyone tell me the best way to set about doing this?

  2. #2
    CJ_London is online now VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    have a table to list all possible errors

    tblErrors
    ErrorPK autonumber
    ErrorArea
    ErrorType

    then to collate your errors something like

    tblNotedErrors
    NotedErrorPK autonumber
    EmployeePK
    ErrorPK

    and in your employee form, have a 3 subforms for tblNotedErrors - user selects errorPK from a rowsource based on a filtered rowsource from tblerrors

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I would like to see a more overall description of what your business involves. From your post I see potential things of interest:

    employee
    work
    application
    assessment
    errorArea
    errorType

    With a complete description of your business in which you describe each of these things and how they relate to each other, you can build a data model/ERD that you can test. And that will serve as the blue print for your database. You need to get the tables and relationships designed to match your requirements.

    There is a tutorial here that can help you. It has problem definition and solution. But you have to work through the tutorial to learn/experience the concepts and process. Should take 30-45 minutes.

    Good luck with your project.

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

Similar Threads

  1. Replies: 7
    Last Post: 11-06-2014, 01:37 PM
  2. Posting multiple Values or entries to one record
    By Northern Lights in forum Access
    Replies: 6
    Last Post: 07-15-2014, 09:50 AM
  3. Replies: 2
    Last Post: 07-09-2014, 12:43 PM
  4. Over type values to create new record
    By Marnhullman in forum Access
    Replies: 1
    Last Post: 02-18-2012, 12:27 PM
  5. Replies: 12
    Last Post: 12-01-2011, 10:28 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