the method i was telling @Kris Wood relies on the applied to/ applying transaction join linking the rows of the related transactions