Use a signal to update different tables

I have the members, colors, groups, members_colors, members_groups and colors_groups tables. The members, colors, groups and colors_groups tables alredy have the needed registers but I need that when a register is added to the members_groups table automatically check the colors asigned for that group and then add registers to the members_colors table with the member especified in members_groups table and the colors asigned for the group that the member belongs.I have the members, colors, groups, members_col