Thanks Jay for the response
1. Yes it is "Parts Explosion"
2. What would you suggest the thing as denormalised dbf. I have a master table with all the items, subassm., assm., etc. Table 2 hsa only the connections and the qty. used in that particular connection. Part1 uses Part5 in 2Qty., Part1 uses Part10 in 5Qty., Part2 uses Part5 in 2Qty., so on.
3. I wanted a tree structure report for costing purposed. The thing that worked me up is that lvl3 item qty. used will be lvl3qty * lvl2qty * lvl1qty * CostFromMaster.
The bissgest thing is that I would not know how many levels I may have to go. Yes I can say 10 and code for the same but when the users goes onto 11 and the whole thing falls apart.
Regards
Bhavbhuti