Hi guys,

I'm having trouble with some many-to-many relationships that are implemented in the project that I work for. This has a historical mechanism that every update on certain tables are registered on a specific table in my database. But some tables which implements a many-to-many relationship and are choosen to registered on historical tables are identified on the historical table as updated but were not updated. Every transaction that involves those tables, certain rows are deleted and included again with the same values. This is the default behaviour of many-to-many relationships - am I wrong about this behaviour?
I'm asking for a help on how to control the updates in tables with many-to-many relationships and not register every transaction; only register when I have the rows updated.


Thanks!