>This is a social-services agency that needs to be able to quickly look up ANY client, so I can't think of a very practical way to further limit the result set.
In that case, can't you limit the result set by client? Look up the information for a specific client, I mean?
Or do you need to search by client first?
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)