Finding only multiple related records

[Stephen Holmes]

Three tables: Attorney --< AttyClient >-- Client. AttyClient contains just the unique IDs from Attorney and the unique IDs from Client. It exists to handle the many-to-many relationship between Attorneys and Clients. How do I find only those Clients that have more than one Attorney assigned to them? In other words, only those Clients that have more than one related Attorney record. Thanks very much.

[Stephen Holmes]

Never mind. figured it out. thanks anyway.

[-Queue-]

Create a calculation in Client of Count(AttyClient::id) > 1. Perform a find for 1 in this field to find all Clients who have more than one Attorney.

[Stephen Holmes]

Argh! I should have thought of that. My much less elegant way was to make a portal to AttyClient, and do a Find duplicates on the unique ID for the client table. Both produced the same results.