kevin_nuclear
New Member
- Joined
- Dec 11, 2013
- Messages
- 11
I am working on a project that has three component requirements that will be tested. A-level, B-Spec, and C-Spec. A-level links ot B-Spec which link to C-Spec. Each A-level is unique, but can be linked to multiple B-Spec. Eac B-Spec can have links to many C-Spec. The C-Spec can also be tied to multiple B-Specs, that is, one C-Spec can be used "multiple" times for different B-Specs, but only is linked to a certain B-Spec once. The C-Specs are tested, which will then allow us to either pass or test a B-Spec, and then pass or test all the A-Specs.
I am trying to build a set of tables and sub-tables that will allow me to note the results of different tests for each C-Spec, then B-Spec, and finally A-level. Should I use my A-level as the Unique key for the main table, B-Spec as the key for the first sub-table, linking back to the A-level and down to the C-Spec, or should I use unique keys for each of the sub-tables and link up and back to the A-level that way? Below is an example of how the data is currently. I cannot get any of the excel websites to upload properly.
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP>
I am trying to build a set of tables and sub-tables that will allow me to note the results of different tests for each C-Spec, then B-Spec, and finally A-level. Should I use my A-level as the Unique key for the main table, B-Spec as the key for the first sub-table, linking back to the A-level and down to the C-Spec, or should I use unique keys for each of the sub-tables and link up and back to the A-level that way? Below is an example of how the data is currently. I cannot get any of the excel websites to upload properly.
Requirement Number</SPAN> | Requirement Title</SPAN> | Percent Complete</SPAN> | Test</SPAN> | Test</SPAN> | Test</SPAN> | Test</SPAN> | Test</SPAN> | |
Flight</SPAN> | Faux-flight</SPAN> | Lab</SPAN> | Simulation</SPAN> | |||||
A-50</SPAN> | Text goes here</SPAN> | -3.57%</SPAN> | ||||||
B-272</SPAN> | Text goes here</SPAN> | -14.29%</SPAN> | 100.00% | |||||
C-448</SPAN> | Text goes here</SPAN> | -100.00%</SPAN> | -100.00%</SPAN> | -100.00% | ||||
C-449</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | ||||||
C-450</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | ||||||
C-451</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | ||||||
C-452</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | ||||||
C-453</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | ||||||
C-454</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | ||||||
B-288</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | ||||||
C-462</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | ||||||
B-7248</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | ||||||
C-523</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | ||||||
B-17312</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | ||||||
C-3568</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | ||||||
C-3569</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | ||||||
C-3570</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | ||||||
C-3571</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | ||||||
C-3572</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | ||||||
C-3573</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | ||||||
C-3574</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | ||||||
C-3575</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | ||||||
A-51</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | ||||||
B-273</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | 100.00% | |||||
C-448</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | 0.00%</SPAN> | 0.00%</SPAN> | ||||
C-449</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | ||||||
C-450</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | ||||||
C-451</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | ||||||
C-452</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | ||||||
C-453</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | ||||||
C-454</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | ||||||
B-289</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | ||||||
C-462</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | ||||||
B-7250</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | ||||||
C-523</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | ||||||
B-17315</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | ||||||
C-356</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | ||||||
C-357</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | ||||||
C-359</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | ||||||
C-258</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> | ||||||
C-852</SPAN> | Text goes here</SPAN> | 0.00%</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP>