Robert,
I have a layer with 5 maintenance area polygons, symbolized by cost center. When I found out I couldn't make a 1-M join work, I added my 40 maintenance employees to the maintenance area table and assigned each of them to one of the cost centers. Now when I search by cost center I get the 1009 error on the search box but on the grid table each of the employees in that cost center show up with their coorisponding field data.
In my map document when I select one of the employees, the area he's assigned to is not selected. My original 5 records defining the maintenance areas are still in the table and when those records are selected, of course the polygon is also selected.
tb