I am trying to create a database that will be able to track inventory of
products that are used to make up different items. Basically we are building
items from a series of individual products. Not all the finished items will
be made up of the same components, but some will use like items. I have
looked at the Inventory template, this seems to be useful for the individual
product components, but how do I create the new finished items.  I thought
about using Parent ID's for these items, but am stumped since many of the
same products are used to make up the individual items. These will be the
items that will be purchased/leased/or rented.  I will also like to
incorporate customers/orders into this database.  When a customer orders a
particular item, I would like the inventory of individual products that make
up the item to be reduced. Any ideas?  One other comment, the items that the
customers purchase will have unique serial numbers, so we can track and
monitor the items. Am I making any sense to anyone? Is this all logical to do
in access? Thanks for any help anyone can give.