Thank you for this very detailed explanation @Gary_Verhaegen . I really appreciate this.
It’s improved my understand for sure, but I think I’ll get to more grips with it in practice. It has definitely made me reconsider the design of my data model and made me more aware of other considerations I need to have that I didn’t realise before.
I’ll open up a separate thread regards my feedback on documentation etc and I must stress this is purely constructive feedback and not intended as a criticism.