MS SQL 2008 R2 Triggers

See more:

SQL-Server-2005

C#

SQL-Server

Hi,

I'm new to trigger, I would just like to ask how can I update the child table automatically when the parent table is updated.

I have here table area and table masterlist

--Area:
CREATE TABLE [dbo].[Area](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Area] [varchar](50) NOT NULL,
 CONSTRAINT [PK_Area_1] PRIMARY KEY CLUSTERED 

--MasterList:
CREATE TABLE [dbo].[MasterList](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[FullName] [varchar](50) NOT NULL,
	[Area] [varchar](50) NOT NULL,
	[MeterNumber] [varchar](20) NOT NULL,
	[MeterType] [varchar](20) NOT NULL,
 CONSTRAINT [PK_MasterList_1] PRIMARY KEY CLUSTERED 

they both have the same field Area.

What I would like to ask is, If I updated the Table Area.Area I would like to automatically update the MasterList.Area.

Thank you very much. Your suggestion is highly appreciated :)