record is updated by who

[rojik]

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

[skhanal]

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.

[rojik]

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.

[rmiao]

You can put trigger in table a. Which rdbms do you use by the way?

[rojik]

Hi Rmiao,

I am using MS Access. Kindly let me know what is the code for that.

Thanks for the reply

[rmiao]

Search 'create trigger' in help.

[rojik]

triggers are only in adp, not in mdb.

Can you help?