HI,
I'm attempting to perform a bill of materials explosion in QV using Hierarchy & HierarchyBelongsTo. My data looks something like this:
| Parent | Child | Type | Qty |
| A | B | Make | 2 |
| A | E | Buy | 1 |
| A | F | Buy | 1 |
| B | C | Make | 2 |
| C | D | Buy | 2 |
| D | G | Make | 1 |
| G | H | Buy | 1 |
My goal it to get a flat table depicting the total BOM structure. The resulting table would look something like this:
| Parent | Child | Type | Qty | Level |
| A | A | Make | 1 | 0 |
| A | B | Make | 2 | 1 |
| A | C | Make | 4 | 2 |
| A | D | Buy | 8 | 3 |
| A | E | Buy | 1 | 1 |
| A | F | Buy | 1 | 1 |
| B | B | Make | 1 | 0 |
| B | C | Make | 2 | 1 |
| B | D | Buy | 4 | 2 |
| D | D | Make | 1 | 0 |
| D | G | Make | 1 | 1 |
| D | H | Buy | 1 | 2 |
| G | G | Make | 1 | 0 |
| G | H | Buy | 1 | 1 |
Any idea?
