I think that you need to do a set null with trigger based ri.