Want a summary field link which links to records in another table.
Associates < Assignments > Clients < Trust Roles
(However, an Associate would only have 1 Assignment relating to any 1 Client)
Embedded Assignments table for each Associate should have a numeric summary field which links to the Trust Role records.
I related Assignments < Trust Roles, but the standard summary field for all records is showing as 0 (whereas the lookup summary field brought through the Client table is showing the number of Trust Roles, but clicking on link goes to Client records instead of Trust Roles).
I have a feeling this is because the relationship between them goes in two directions, so I'm trying using an =1 method, with a numeric summary field that's value is 1, but I don't think I'm doing it right.