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!