Hello,
at first - excuse my bad english, but nevertheless i have a problem. 😉 I hope you can help me...
I have a trigger on one table for the insert command. this trigger inserts a record into another table. it works fine for the second table...
CREATE TRIGGER NeuBugtracking ON [dbo].[ProjekteBugtrackingT]
FOR INSERT
AS
INSERT INTO ProjekteBugtrackingTexteT (BugZahl)
SELECT (bugid) FROM Inserted
the problem is that the identity for the first table will not be generated immeadetly...through this specific conduct im getting error messages in the front end app (access 2003). the same happens if i try this in em. the record is updated correct but i can not edit it again till i load the entire recordset again -> wrong identity information.
do you have any idea?
best regards
andreas