Hi @Sharon_Watson - if I understand you correctly, you’ve got a set-up something like this:
Note, my fake column where I’m assuming a contract row is related to a contract, but you just don’t have that link in place, yes?
So when you cancel a contract, you mark a User as cancelled, which then ripples out across all their rows.
I can’t see any way around your issue tbh. I think the answer is to create a link between a contract and a contract row, then delete the link between the contract row and the user (it will still be linked once removed via the contract). I don’t know if this is possible for you - this might be many records and very manual, but I think this would give you a better base design if you can make the change.