@JohannesLindner @XanderBakker
This solution did work, though now we have run into a different but related issue. We are working with data that is in 3 layers, i.e. there is a related table to the feature class, and then another related table to the first related table, via a different ID field. It looks like this:
![AbidHiraSaath_0-1639899273437.png AbidHiraSaath_0-1639899273437.png](https://community.esri.com/t5/image/serverpage/image-id/29996i7F703E5501B6A333/image-size/medium?v=v2&px=400)
The original point table
![AbidHiraSaath_1-1639899312867.png AbidHiraSaath_1-1639899312867.png](https://community.esri.com/t5/image/serverpage/image-id/29997iD52C1B3A9D952FBC/image-size/medium?v=v2&px=400)
the first related table, related through stopNo
![AbidHiraSaath_2-1639899354640.png AbidHiraSaath_2-1639899354640.png](https://community.esri.com/t5/image/serverpage/image-id/29998iC85C3432601FC1A4/image-size/medium?v=v2&px=400)
The second related table, related to the first table through busNo
What we want to understand is, how can run a calculation on the second realted table through the original point layer? For example, if we wanted to know the sum of all the passengers in the buses that went through point A01, how would we do that?
When we use featuresetbyrelationshipname, using the name of the second relationship class, it reruns an empty featureset.
Can you please help me out regarding this?