Simple Trigger Question

[MrMike]

I'm building this trigger and an error message is appearing which says: "
Error 170: Incorrect Syntax: Line 6 near "=". Could someone please help me
understand why this error is occuring? Thanks.

Create Trigger AvailableLogFootage
on tblLogs
FOR UPDATE
As
Begin
UPDATE UnDesignatedFootage = tblBundles.CurrentFootage
WHERE tblBundles.IsDesignated = 'N'
FROM tblLogs join tblBundles
On tblLogs INNER JOIN tblBundles ON tblLogs.FlitchNum = tblBundles.FlitchNum

[John Spiegel]

Hey Mike,

Looks like you need to tell it what table to set and a SET keyword to tell
it where the fieldlist starts:

UPDATE MyTable SET UnDesignatedFootage = tblBundles.CurrentFootage
WHERE ...

HTH,

John

"MrMike" <Mr****@discussions.microsoft.com> wrote in message
news:2D**********************************@microsof t.com...

I'm building this trigger and an error message is appearing which says: "
Error 170: Incorrect Syntax: Line 6 near "=". Could someone please help me understand why this error is occuring? Thanks.

Create Trigger AvailableLogFootage
on tblLogs
FOR UPDATE
As
Begin
UPDATE UnDesignatedFootage = tblBundles.CurrentFootage
WHERE tblBundles.IsDesignated = 'N'
FROM tblLogs join tblBundles
On tblLogs INNER JOIN tblBundles ON tblLogs.FlitchNum =

tblBundles.FlitchNum

[MrMike]

That was it! Thanks John

"John Spiegel" wrote:

Hey Mike,

Looks like you need to tell it what table to set and a SET keyword to tell
it where the fieldlist starts:

UPDATE MyTable SET UnDesignatedFootage = tblBundles.CurrentFootage
WHERE ...

HTH,

John

"MrMike" <Mr****@discussions.microsoft.com> wrote in message
news:2D**********************************@microsof t.com...

I'm building this trigger and an error message is appearing which says: "
Error 170: Incorrect Syntax: Line 6 near "=". Could someone please help

me

understand why this error is occuring? Thanks.

Create Trigger AvailableLogFootage
on tblLogs
FOR UPDATE
As
Begin
UPDATE UnDesignatedFootage = tblBundles.CurrentFootage
WHERE tblBundles.IsDesignated = 'N'
FROM tblLogs join tblBundles
On tblLogs INNER JOIN tblBundles ON tblLogs.FlitchNum =

tblBundles.FlitchNum