Table setup for rollup

[jwillet1]

I have a table that i have to incorporate in to a tool I am currently working on. It is a large (3200 line) excel table. the 3200 lines are our level 6 test conditions. Each of those will roll up from level 5 to level 1 becoming grouped until level 1 includes only 3 lines.

My question is this, should I have a table for each level and relate them to each other or one table that stores all the levels from 1 to 6?

I have attached an excel stub showing an example layout of the test parameters and grouping.

Thanks for any help.

 

[spikepl]

You did not mention what you wanted to do with this.

 

[jwillet1]

The database is used form logging test procedures for timing tracking. An engineer will log a test at the lvl 6 requirement and log the time for that test run. As we have close to 300 engineers you can see how the amount of lvl 6 items will increase very quickly for a given product. Management then sees weekly reports based on that timing. I could see management requesting reports on any or all of the levels I had mentioned in the OP.

 

[spikepl]

Your explanation shed for me no light on the role of levels 1-5 in this Access application. If tests are at lvl 6, what have the other levels to do with this?

Bear in mind that people tend to recreate Excel worksheets in Access, which is throwing the baby out with the bathwater, becasue Access is not Excel.

Design the thing to hold data the way normalized data should be held in Access.

The user interface (for input or for output is a different and not entirely related story.

Show your data structure once you have settled for one - a screenshot of the Relations window