Good morning,
I hope someone can help me with this.
I have an order database. In a form ORDER, I can select products from the table PRODUCTS, which will be placed in a table ORDERCONTENT.
so far everything works without problems for years. But I have 'stock' problems with products that contain 2 other products. for example:
Product 1 €100
product 2 €60
product 3 €50
Product 1 contains, both products 2 and 3. If I sell it as product1, it wil be €100,- But when I sell it separately It will be more expensivve when you buy both. Of course this is working, when I just put all these products in the table. But the problem is the stock counting. In my stock, I just have product 2 and 3, and of course not the complete Product 1. So What I would like to do is mark items like product1 as a containeritem, which I can select in my form. But then it should show the containeritem (product1) + the underlaying products 2 and 3 on te next rows automatically. (Of course I count the stock then with the underlaying products. )
I hope this is a littlebit clear. For me the biggest question is: How can I choose 1 containeritem via a dropdownbox, and then fill automatically the next 2 rows in the table with the depending Products 2 and 3 If I know this I will be helped a lot.
please see also my attached "explanation"
Thanks already!!