Easiest way to implement history for 1:N relationships RRS feed

  • Question

  • Hi, I have two entities that have a 1:N relationship, however different items on the many-side will over time be assigned to different "owners", and I need to keep this history.


    A assigned X (in the past), Y

    B assigned X (active), Z

    This could be implemented by some N:N relationship, perhaps with a intermediate entity, which holds a flag for the active owner. However this seems a bit cumbersome to work with, in most cases only the active ownership is of interest, lookups and views will mostly relate to the simpler 1:N model.

    Do you have any suggestions how to keep the 1:N relationship, and at the same time preserve a "history". Can auditing be used for this? Perhaps a workflow updating a secondary N:N relation between the entities? (e.g. on change of linked item, add item and linked item to N:N intermediate link entity lookups)

    Thanks for your help!

    Thursday, November 12, 2015 10:02 PM

All replies