Not sure how to relate these tables

[jwillet1]

I have a DB that is being used to track testing for various programs. The goal is to log the various phases and testing parameters that each program will go through. Each program will have multiple test vehicles. My question comes in the, attached picture, the area outlined in blue.

The issue is, each time an experimental run is done multiple ASR line items can be tested. This is the reason I have the "test groups" category. However it is possible that a given ASR line item in a test group could fail to meet requirements. Therefore it must be fixed and then retested. However the other line items in the test group were fine. Therefore for the retest only the failed Line item needs to be logged. This is why test group and ASR Line item are located on the test data table.

On the test data input form I have an ASR line item selection box disabled unless a specific "test group", "other/individual Item", is selected. This allows the user to select a single ASR Line item that is being retested or what not.

I guess my question is, is this the best way to do this, could this have repercussions down the road that as a novice i cant see now? If this way is not good, is there a better one?

Thanks for all help.

 

[jwillet1]

I know this is a late reply, however i have been actively trying to come up with a solution that works.

Pat, I had considered that, however without TestGroupID the only way to store test data for a test run that gathers data for multiple ASRLineItems, is to store multiple values in the ASRLineID field on tblTestData. Which I definitely don't want to do.