Hi
I would have a problem... <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=13280&image=1&table=forumtopics' class='bbc_emoticon' alt=':(' />
Sample...
I have 2 table.
- Data
- DataMod
In Data i have 3 field: id, Name, Year
In DataMod i have 3 field: idDataMod, idData,UserName
When I modify (edit) a record in the first table (Data), I would want to write in DataMod the name (username) of whom has performed the login
and the ID of the record (table Data) that has been modified.
As it is possible to read the value of ID?
In Table Events -> After record updated i have write this code:
USERNAME = UCase(Session("UserID"))
IdDati = values("id") ID is id from DATA table... !! How read the value of the field from the table DATA ???
strSQLIns = "insert into DATAMOD (Mod_id, Mod_User) values ('" & IdDati & "', '" & UserName & "')"
dbConnection.Execute strSQLIns
Many tnx !
Stefano