And exactly what match fields did you set up and what is the context for your layout where you want to see this list of only active clients?
I would guess that you set up a relationship like this:
Clients::ClientID <> NonClients::ClientID
That won't work for what you describe.
But try two occurrences of Clients and you can exploit a return separated list of values in a single field to exclude records from clients.
Define These Relationships:
Clients::anyField X NonClients::anyfield
Clients::cExclusionList <> ActiveClients::ClientID (ActiveClients is a second occurrence of Clients.)
Define cExclusionLIst as List ( NonClients::ClientID ) with Text specified as the return type.
If you need to see this list in the context of a different table, use an occurrence of that table in place of the Clients table occurrence in both relationships.
Note: with FileMaker 12 there should be ways to get this list in a single field or just the exclusion list of clientID's without needing as many occurrences of different tables to make this work by employing the ExecuteSQL function.
I went the SQL route.
Added Custom Function: ValueExists(Value;ValueList) -- [is the Value in the ValueList?]
n = ValueCount ( ValueList );
If ( n > 0 ;
If(Exact(GetValue ( valuelist ; 1) ; value) ; 1 ;
ValueExists (value; RightValues (valuelist; n -1)))))
Added a calculated field, ActiveFlag, to Clients.
Calculation: ActiveFlag = not ValueExists(bBusiness num;ExecuteSQL ( "select ClientNum from NonClients " ; "" ; ""))
Not IsEmpty ( Filtervalues ( ValueList ; Value ) )