1 of 1 people found this helpful
List( Clients::Name )
From a procedures layout would show a list of related values from Clients.
You could also add a "Client Name" field to your Procedures table, then set it as a looked up value from clients. You could then summarize that field as it would be in the same table.
I'm sure theres probably a way to do it with GetSummary() as well.
Another alternative, depending on what you are printing out, would be to do a subsummary part based on Client ID with no body part under it. Sorting by Client ID would then result in a list of "groups" of unique clients from the clients table on your procedures found set.
As well as Mike's excellent suggestion you could use Execute SQL.
I tend to favour this method as it gives me more control over the relationship and subsequently data set as well as the option to structure the results in one command which again gives me more power to structure the presentation of the result.
I actually wouldn’t recommend ExecuteSQL in this case because you’d have to match conditions from an entire list of results. Not only would that make the SQL call overly complicated, but performance would suffer as well. (It is an option though!)
Thank you Mike,
This is just what I was looking for!