Inventory Sales: Product made of Parts

[Justin_Cap]

Hello All,



I have a Products table and an Orders form. When a Product is chosen on an order and the sale is completed, the sales count for that product goes up by one. Some of my products are actually assembled using other products on the table. So, when these products are placed on a completed order I need, instead of that assembled product, all of the associated parts sales count to increase by 1 (or however many of those parts are needed for that assembled product).

Any advice is much appreciated!

[Beetle]

Welcome to the forum! In order to be able to give you any meaningful advice we will need to know more about your application. You can either give us a detailed description of your table structure, queries, forms, etc. (maybe some screen shots), or you can upload a sanitized copy of you application that we can look at.