In the database I'm working on (2003) I have a client table that includes a client status field, and I have a linked notes table that includes the note entry date, note type, and note details. Each client has multiple notes.

Each time the client status is changed in the client table, I would like to have a note automatically created in the notes table that details the status change and the note type.

For example: if...