Working on some coursework and wondered if anyone could help us.
We have set up a table that is supposed to be a log of whenever another table is updated. We have looked and looked and tried and tried but cannot work out how to set the log table to automattically update.
We assume that triggers are the best way but we aren't sure. Can anyone help?
the tables are...
entry(e_code, c_code, id, position)
log(e_code, c_code, id, position stamp, user_id)
where stamp is the time of the update and user_id who has done it.