sql - Structure of first database design -

i’m trying create database operator (me in case) receives log , assigns multiple people review log based on various subsystems represent. example, test run called x. once x run, receive log of x , assign 5 people representing different subsystems review it. i’m trying manage reviews , see if reviews outstanding. structure hoping for, , have implemented far consists of following: have 2 forms in enter data, 1 run information enter, , 1 reviews other people enter. problem i’m running how i’m able view has done each review. below picture of relationships have of database (the 2 letter acronyms represent subsystems i’m assigning):

i thinking creating query able search last name , show had done review based on whether or not had checked done review box on review form. problem unless person created review review wouldn’t exist @ wouldn’t able query whether or not had completed based on check box. other idea had add check box each sub system in run information table , map check box in review form check box in run information table based on run id , domain info entered review form. haven’t been successful in either haven’t found way dynamically update control source of check box in review form. have ideas of how’d they’d implement or i’m missing? first dealing database development , i’m @ loss right now. thanks.

the tables have one-many relationship , can use ms-access build tables, queries , master /detail form wizard.

you can modify vba code.

at least starting system.

edit:

master form: runinformation

detail form: review

link join field between master/detail: runid

in case , runinformation in master form , can insert 5 records assignment each sub system

you can crud operation master/detail

q: "what i’m trying manage reviews , see if reviews outstanding."

a: add button in master form filter master/detail form status "oustanding".

note:

modify structure of "runinformation" , remove columns of subsystem (like hw,sw,..),and add status column in "review" table , column subsystem (hw,sw). can combo box in review form, , status checkbox.