Is it possible to have a cascade upwards query?

Scenario being two tables with a linking pair of fields, where one table is a superset of the other and key is generated by the second table

I would like to have the record in table two deleted when I delete the record in table 1

Thanks