How to add a record in a portal but in multiple records
I know that the subject seems a bit strange but here is my problem :
Table A : list of shops
Table B : list of all available products (and details) to sell in a shop
Table C : list the products sold in each specific shop (visible via a portal in table A)
A <- C <- B
In my case, I made a script that add all the products available when I create a new shop. It means that all the products available are in all shops.
But my problem comes when I have a new product available. How can I "easely" add that new product in all the shops.
All tables have ID fields automatically filled with a serialized number.
Thanks for the help.