trigger on table to update another

[max1x]

Using phpMyAdmin a table was created where a column is defined using SET from GUI.

I have created a master table which provides data to all the secondary tables via a one to many relationship. I wanted to check with the experts before I start messing with live tables.

Can I create an AFTER INSERT trigger on the master table, with an insert into a target table on a colum that is set via SET in phpAdmin? If so, what would the query in the trigger look like? This is a varChar insert...

something along the lines:

insert into tTable colum('x') values ('y') where (select distinct t1F3 from sT where t1F3 not in (select t2F3 from tT));

Any advise would be great.