Can you post your code? Basically you have to code your trigger as though you are joining a table, not a single value.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones