I am designing tables for a BOM (Base of Manufacturing) system. Example below illustrate the sample data I have
How to create this table base on above info in order to have recurring call for the same table for report generation . Anyone can suggest ?
Say I have one ModuleNo : A, under this ModuleNo A, below are its children
Level DwgNo StdQty
1 AAA 2
1 BBB 3
1 CCC 1
1 DDD 1
2 EEE 2
2 FFF 2
2 GGG 1
3 HHH 4
3 III 1
3 JJJ 1
1 KKK 5
1 LLL 1
1 MMM 1
How to create this table base on above info in order to have recurring call for the same table for report generation . Anyone can suggest ?