I'm designing a Court Case Management database. I am currently using a many-many relationship for CaseID and ClientID. What I would like to do is similar to IMDB's Credited With option. For a conflict checker, I would like to see if any clients have been in any cases with any other clients before. My brain can't seem to figure out how to word the query.
Any help would be appreciated