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.
e.g.
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!