Hi everybody,
Let's assume I have 3 tables:
- Tools
- Users
- Requests (= Audit Log)
Users can create a request to get access to a certain tool. When the tool admin approves the request, the user is linked to the tool. That's fairly simple and already working.
Now tool admins can also add ore remove users directly to their tools, by linking or unlinking them.
In that case, I want to automatically create a record in the Requests table that contains the user and the tool that was either linked or unlinked, as that table serves also as my audit log.
Any idea how I could solve that?