Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FPD25 - Recursive SQL, data, tree and my SQL below
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00518869
Message ID:
00519194
Views:
11
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
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
___________________________________________
venussoftop@gmail.com
___________________________________________
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform