Auditing of Account and Security Statements; Error when trying to add an invalid Client Id to an existing Account or Security Statement

1. When trying to add an invalid Client Id to an existing Security Stmt then clicking save, the following message appeared:

ERROR MESSAGE
=============
Failed to save Security Statement.

Failed to save Audit Log.

Failed to save Client Log.

Failed to add new record in UpdateQueryBuilder.

You cannot add or change a record because a related record is required in table 'Client'.


2. When trying to add an invalid Client Id to an existing Account, the Client was not added but an Audit record was created saying a blank Client was added.
3. When trying to add an invalid Client Id to an existing Account that is linked to a Security Stmt, two audit records where created for the Security Statement even if the Security Stmt was not edited.



Changes.
========
No Audit records are written when trying to add an invalid Client Id.