-
record is updated by who
Hi,
I have a databse with userid. I have a form which enable each each user to logon. What I like to do is to add the username of current user logged in to each recored he updates or creates.
I really appreciate your help.
Thanks
Roji
-
You have to have a column to keep that information in each table and you need to write code for it, either on front end or as triggers.
-
record is updated by who
Hi skhanal,
Thanks for the reply. What I was looking a for a code for that, and when this will be updated in another table. I can have a separate column in the main table. but that will not keep history of each record. For eg. Table A is the main table. Table B has all user names. Table C is the History table to track record updates like when and by who. Each time a recod is updated in Table A, there must be an insert in Table C with the date of change and by the user
Hope you can help me with this. I am beginner in this.
Thanks.
-
You can put trigger in table a. Which rdbms do you use by the way?
-
record is updated by who
Hi Rmiao,
I am using MS Access. Kindly let me know what is the code for that.
Thanks for the reply
-
Search 'create trigger' in help.
-
updated by who
triggers are only in adp, not in mdb.
Can you help?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|