Common stock level for multiple products

I think what I am looking for is similar to stock by attributes but not quite the same.

Example.
If I have a category called clocks, in that category I have 2 sub categories called photo clocks and design clocks, in both sub categories there are blue, red, green, white and pink clocks.

I need a database table that has stock levels for the coloured clocks and then the products get their stock levels from the new table, so if I have 10 blue clocks, 8 green clocks and no other colours in stock. When a customer goes into photo clocks and clicks the blue clock product it shows 10 in stock, same if they go to desin clocks and click blue clock product, but when someone buys either of them the stock level for all blue clock products reduces to 9.

I hope that makes sense, it makes sense in my head but quite hard to explain, I hope someone can help with this or at least point me in the right direction of how to make a product consult a new table to get it's current stock level.

Thanks

If it is the same product, you can link it, so that you dont have to manage it seperate. See the tutorial.

It's not the same product but multiple products use the same raw materials (stock)

Can anyone help me with this issue?

It probably shares aspects of code with Stock by Attributes, but would require a lot of new coding and database work. Nobody is likely to take this on unless they need it or they are being paid for it. Sorry...

I might have an idea how to make this work if somebody could point me in the right direction. Which part of the code is responsible for checking if a product is at zero quantity or positive quantity and also which part of the code is responsible for deducting from the available quantity once an item has been purchased. If I knew where to find those two little bits, could I change it to look at a specific row of a new database table?

Thanks