The end user wants all records suppressed for a person if that person has any records in another table. In SQL would do this by
Select table.id, table.name from table where table.id not in (select table2.id from table2).
Tried in the select expert to use the following
where table1.id_number not in the list of table2.id_number
using Crystal 10 - worked once, never worked again in Crystal 11 did not work at all. Verified the tables I'm using had not changed. Would appreciate any help.

Will give that a try. Current have it working with a suppress on the detail line - with basically what you have suggested.