Separate design query's

hi

i have two designs one is a bin delivery which is applied to the nlpg and one which is a remove/abandoned bin which is applied to the highways networks asset.

im trying to do a workflow which is essentially when a abandoned bin is created if there is a bin delivery ( made against the property) on the same street for it to send an email to a supervisor.

it sounds simple to do but am struggling to produce as the only thing that connects them is the network interface , but its querying if there is a match on the street/network reference.

anyone any idea?

the query produces the results of streets where there are outstanding bin delivery’s and abandoned bins issued, but this is as far as im getting