Recording an update to a record.
Can you help me please... I have a db which holds pretty important contact information.
The db is relational to a 'notes' db where we can add information relating to a specific record.
What i would like to do is automatically record in the notes db if the main contact information db is updated in any way. i.e. 'user:Julie' update the 'field:phone number' on date:14th march 2011.
I have set up account/user priveledges etc but any help would be appreciated.