creating table from query (1 Viewer)

[Ramnik]

hello everyone,
i have a production database application in which there are many sections. every section's product stock is generated by running a complex query.

now when i want to add the result from different sections into a one combined stock , i could not design the query as it become too large and on running it produces the error "cannot open anymore database".

i think reason might be too many queries executing at same time .

so do i need to create a table from the stock queries of each section? and then add the tables to generate the combined stock query ?????
if so what is the method ?

 

[Galaxiom]

It shouldn't be that hard. Sounds like the data structure needs work.

Tell us about how your tables are structured and related.

 

[Ramnik]

this is the attached image for the logic that i have designed
it is sequential floww of products through different sections //...
one section's pass quantity is fed into next section's input qty .... and balance is maintained as stock..

i am getting problem in adding the stock queries for each section ..
thanksssss

 

[Ramnik]

hello everyone ..... does anyone knows a better design for the above problem . table structure is attached above ..

and if i create a table instead of query for each section's stock wont it be easy for calculating the total stock query .....

thankssssss