inserting multiple record using drop down
Lets say a product needs to be added & product got multiple categories. so from dropdown he chooses multiple categories.
But this multiple categories i want to be inserted in different table ei: CatProduct
It contains ID, ProductCatID, ProductID
ProductCatID will be category id choosen while adding product. & ProductID is current ProductID
Now when i choose multiple categories i want multiple records to be added in CatProduct table. But it isnt happening!
How can it be achieved?
Current when i test only one record is getting added in CatProduct.
If i choose 4 categories then 4 records must be added in CatProduct.
I choosed "insert multiple record" but isnt accepting it. (dw) even tho repeat region is added in multiple dropdown option!