Problem with AuditTrail

[Uncle Gizmo]

Have you any ideas how to make this work with a m:n (many to many) relationship? For example if I want to see past users of the pc (that would be possible with the data model in the example database).

I think you should start a new thread with a copy of your latest DB in it. You can then explain in terms of your existing DB where it is lacking.

 

[jdraw]

I reconsidered my data model and built a new one from scratch.

Please show us your new design/database.
I'd like to see the business facts/rules that you used in order to compare it with your design.

As for new thread ---that seems reasonable.

 

[daikaio94]

Hello,

I threw another example together. This time I included the search function I'm using and the audited form is now a subform as it is in my main Project. I still need to make adjustments to the code for using it in a subform but that is no problem, just didnt had the time yet.
Some of the code is commented in german as I simply copied it from my main project, if you want to know anything feel free to ask.

As for the data model I'll try to explain it simple.

There are many users/uses (Verwendung)
There are many PCs

One PC can have one user/usage
One user/usage can have many PCs

Thanks again for all the help!

 

[jdraw]

Glad you have it resolved.