What you are trying to do here is manipulate inventory items such as
would be done when bundling/packaging/assembling a finished product
inventory 'kit' from existing inventory items/services. This is not a
trivial task in any way/shape/form!! (Otherwise there'd be existing
solutions available from Excel developers)

Extensive use of database tables is required to keep track of this,
meaning a solution will require database programming be included at a
significant level. Better to choose/use accounting app for this. (If
you're already a functioning business then you should already be using
such an app, IMO)

Many accounting software apps offer this feature in a number of
configurations, depending on brand of software. Some include a way to
flag a 'shorts' list so you know what has to be ordered if not 'in
stock' at the time the 'kit' is built. (They even have ability to
generate POs to the respective supplier[s]) First one that comes to
mind is Quickbooks by Intuit! Another possible solution is Inventoria
by NCH. There are others (by Sage) I'm familiar with but they're not
cheap ($1000s to buy, + seat costs).

Maybe you need to re-think this?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion