Auto update of username and timestamp when a record is modified
Hi every one .
I am very new to this technology. In my database file i have a field called "notes" of length 5000. Whenever a user enter data into that field it has to display the user name and timestamp followed by the data he has entered.
For example first the user "user1" is modified. Now it has to display the user name and timestamp followed by the data. Next time if "user2" has modified , it has to display his username and timestamp followed by the data.
Now this field should contain "user1","timestamp" followed by the data and "user2", "timestamp" followed by the data and so on.
Example data in the field: Rakesh(user1), 14:02:10. Hi everyone
Danny (user2), 09:10:11. Hello all