triggers u

[Jayaraj Jaganathan]

I have a two tables

Table1: master_project
Table2: project_team

CREATE TABLE master_project (project VARCHAR(20) PRIMARY KEY );

CREATE TABLE project_team (project VARCHAR(20) , team VARCHAR(20) );

when i insert project name in project_team table
a unique project must to be inserted automatically in master_project table.

How to do this.?

thanks in advance.

[e-mail]
[e-mail]