A couple problems:
1) If you search on 'food pantry' in mvh.csmith.testing123.net , you get (3) 'Food Pantry' entries under program.
2) The three sets of results (agency, category, program) are a bit confusing.
So....
1) Disambiguate the program results by prepending the first 42 char of agency name (96% of agencies have names =< 42 char)
2) append "(main agency record)" to agency results
3) combine agency results with program results
4) Sort results alphabetically
...leaves us with 2 sets of results: Agency+program, category
A couple problems:
1) If you search on 'food pantry' in mvh.csmith. testing123. net , you get
(3) 'Food Pantry' entries under program.
2) The three sets of results (agency, category, program) are a bit confusing.
So....
1) Disambiguate the program results by prepending the first 42 char of agency name (96% of agencies have names =< 42 char)
2) append "(main agency record)" to agency results
3) combine agency results with program results
4) Sort results alphabetically
...leaves us with 2 sets of results: Agency+program, category