my best guess, which sucks and makes no sense woithout the sample DDL of the tables, and the trigger you were trying to build:
CREATE TRIGGER TR_Sales_CloneToDepartment On Sales
FOR INSERT
AS
INSERT INTO Department(Account)
SELECT Users.UserID
FROM Users
INNER JOIN INSERTED
ON Users.UserName= INSERTED.key3
Lowell
--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!