I had used this same logic as you said earlier. adding multiple records for categories. But i faced problem in edit records
How will edit product page work with same above example given by you.
Like Product 'x' has two category another category needs to be added or change or removed.. How will edit-product page work?
What are thr RS required & how to link?
In add product page i used repeat region on Categories & then checkbox for them.
i got no problem in add product page but facing problem in edit-product!
attached file contain insert record how will edit work for this?