the logic is to trace where the user is in the application at a certain period, and display the information on the application accordingly. So i added a column and i am trying to figure out the data from different table and update the related column accordingly.

an update would do that for existing records but for new records i need the column to update each time the records change in different table. i hope that made mo sense than my original post