Results 1 to 5 of 5
  1. #1
    per007 is offline Novice
    Windows 10 Office 365
    Join Date
    Sep 2021
    Posts
    1

    Measure progress

    Hi,


    I have 4 tables, please see attached. I'm wondering how I could save scores for DialogIndicators under a Progress table. Any thoughts are welcome, many thanks!

    Per

    progress.accdb

  2. #2
    Cottonshirt is offline Competent Performer
    Windows 8 Access 2007
    Join Date
    Feb 2018
    Posts
    116
    questions
    1. what does a score consist of and how do you arrive at a score?
    2. what does "progress" consist of.


    good luck with your project,


    Cottonshirt

  3. #3
    alcapps is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jan 2012
    Posts
    292
    It seems like the Progress table should point to the DialogIndicarorID. That is where you have you many to many connection. Once you put that ID there you can score the values tied to the combination of Dialog and the Indicator.

  4. #4
    alcapps is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jan 2012
    Posts
    292
    I typically add the score and date to the many to many table and keep that table as the many to many table with values instead of breaking them out.

  5. #5
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    If the score is calculated, it probably should not be stored at all - rather calculated when needed.
    According to your relationships, one company can only ever have one instance of a particular indicator. If that's not the way it's supposed to be, then the design is incorrect. I'd use a composite index in DialogIndicator, not a composite PK regardless. The use of a composite PK in Progress looks odd, but then we know nothing about the process.

    You cannot simply link the 2 fields and enforce referential integrity if it is the plan to do so as in the other relationships - because DialongIndicatorID is not a unique field. By using a composite PK in the table, you'd be forced to add a 3rd field to the composite PK because you cannot have a composite pk and a primary pk in the same table as I understand it.

    Might be a good idea to research db normalization, or provide a detailed overview of the process that the db supports. I'm also thinking that company names belong in their own table.
    Last edited by Micron; 09-10-2021 at 02:01 PM. Reason: added info
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. How to measure procedure's progress in Vba?
    By robs23 in forum Programming
    Replies: 13
    Last Post: 08-20-2014, 10:47 AM
  2. Units of measure converter
    By gaker10 in forum Programming
    Replies: 5
    Last Post: 07-02-2014, 12:20 PM
  3. Weights and Measure Query
    By The Grand Pooh-Bah in forum Queries
    Replies: 2
    Last Post: 02-20-2013, 08:25 AM
  4. Handeling Multipule Units of Measure
    By Waldenbound in forum Database Design
    Replies: 1
    Last Post: 09-02-2011, 08:24 AM
  5. Unit of Measure
    By Lghtning4u in forum Forms
    Replies: 0
    Last Post: 07-25-2007, 04:08 PM

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