Help with triggers

[Legion13]

I have a trigger that is fired off when a location field in a workorder record is updated. The problem is, the trigger needs to update 6 other fields in the same record and this causes a deadlock in SQL Server 7 because the record is already in the middle of an update. Does anyone know a workaround for this?

Thanks in advance for any help.

 

[foxdev]

Could you accomplish the same thing with Defaults? Robert Bradley

http://www.foxdev.com/

Got extra money lying around? Visit:

http://www.agrainofhope.org

 

[Legion13]

Unfortunately no. Essentially what I have to do is pull the names and phone numbers of the various facility managers for a specific location code. Since there is no direct reference between the two tables the maintenance software can't make the link itself, so I must use a trigger to do so.