This Rogerio_Penna is a nice fellow. I often meet him, when I look at the mirror haha.
(created a topic about it)
@dmitry-grist I wonder if this sort of behavior couldn´t be directly integrated into Grist. Whenever a reference is created a hidden (just like the ID column is hidden) column is created in the referenced table. Maybe when creating a reference, there could be a check for “protect orphaned data”, if checked, the lookup column is created at the referenced table and the Access Rules are AUTOMATICALLY created
I talked about some other similar functions here (editing and saving records buttons, based on status column functionality and Access Rules based on those status columns.