>After Bill of Material (BOM) Explosion on each Parent Assembly number with multiple level, all the parts that included in the BOM will be saved in Excel file. Each part will be multiplied by the assembly demand. For instance, Assy 1000001 has a component part that requires 3 per build and the order for this assy is 5; then quantity required will be 3x5=15. This will show up in the qtyrequired column in order to build 10 assy 1000001. Am I clear on my explanation? Sorry, if its a bit confusing. Thanks, Sam
As I said, can you post some simple data from all tables and desired result from that data?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.