KB10600 - Limit records displayed from joined database.
This can be accomplished just by narrowing the scope. For example, to limit display of records to only those associated with New Zealand, use something like:
Layer.Scope = "location LIKE 'new zea%'"
Created: January 14, 2005, Modified: September 10, 2015