Never tried, but I think it’s possible. Child records will have a reference to main table. Each main record can have a cell where it lookUpRecords in the child table that reference their id.
If the lookup returns more than 0, you can have it return “yes”.
Then in the Rules table, you can set a rule for users where they can´t delete records if their lookupcell = “yes”.