Hi everyone,
I have Table A with a list of suppliers, Table B with a list of generic products (linked to multiple suppliers from Table A), and Table C with a list of specific products linked to a specific generic product from Table B and a specific supplier from Table A.
I would like from Table B that when I add a new supplier to a generic product (in the supplier field linked to multiple suppliers), it automatically creates a new record in Table C, with the specific supplier associated to the generic product.
Any help on this would be much appreciated ?