Hi,<BR><BR>first time using triggers. Can someone just have a quick check of this and let me know if its the right way of inserting a value into a join table?<BR><BR>CREATE TRIGGER texture_cascade_insert<BR>ON tblTextures<BR>FOR INSERT<BR>AS<BR> DECLARE @PicoInsert int, @Owner int<BR> SELECT @PictoInsert= @@Identity<BR> SELECT @Owner = Pic_owner<BR> FROM Inserted<BR><BR> INSERT tblPicturejoin (Picture, Owner)<BR> VALUES (@PictureToInsert,@Owner)<BR><BR>I&#039;m setting the variable @Owner to the Owner value set in the record. How would I go about setting the owner to the currently logged in user (Session("Usr_identity"))?<BR><BR>Thanks in advance,<BR><BR>Ian