Hi i was wondering if the below is possible
1. Combine the current and deleted users into one table (obviously yes)
2. Have a checkbox (column) which is ticked for current and unticked for deleted
3. Whenever the checkbox is selected (ie tick box added or removed) a dialogue box pops up asking to state reason
4. The reason is kept in an audit table with timestamp, userid, added/removed
5. Examples of the reason are Switching with another user, New License
Licenses for users are being changed at a daily rate and i need to keep an audit trail of all changes.
Thanks in advance or if you could suggest a better way of doing this.