Yes, we did that and it does work. It does still seem to scan everything so it's no faster, but I did get it to return a list only with the one vendor.

Maybe this is something that can be looked at for the future - i.e. some way to scan the database that will be fast. The client insists it was much faster with the old program.