Table Setup for Future Multi-level Report

[AggieLJ]

I will eventually need a report that will look like the example below, so my question is:

How would I structure my tables to get the information to be able to be displayed this way?

(A little background: I work with lab numbers with a possibility of having multiple tests required of each, and they are supposed to be grouped by the test being performed.)

For Example:

Quantity:___Test Number:____Description:________................
____2____________S1___________________Test does this....
________________Lab Number(s): 12345______Customer's sample ID
________________________________23456______Customer's sample ID
____1____________E1___________________Extra test does this....
________________Lab Number(s): 12345______Customer's sample ID
.............

(Then totals, payments....everything else)

BOLD = Label


Thanks in advance for your help!

 

[Pat Hartman]

Each level of the hierarchy should have its own table. The higher levels may just have an Id and descriptive text but that is fine.