Chad,
Yeah what a great utility this was. If I recall it correctly, the program was about 50K in size. The most incredible feature was the fuzzy search algorithm. I used to work for a company that used Friendly Finder as a search tool against their ERP system. When the company wanted to upgrade the ERP system to Btrieve, the users refused to upgrade without a replacement for FF. So I had to come up with another solution. I did some extensive research on the net and couldn't find anything comparable.

Anyway, what I ended up doing is creating a replacement in VFP. We bought phdBase which is a great tool. It offers fuzzy searching and is *much* faster. The fuzzy search algorithm doesn't match Frienly Finder's but most of the time you get good results. I created an interface similar to FF with two grids. The top grid contains the field headings and 1 row in which you can enter the search criteria. The second grid below displays the search result. There are some additional features such as incremental search in the result grid, reordering by clicking on the header, cached search results, etc.

If you're interested, I can send you the form. It's quite customer specific and you won't be able to use it as is. But it might give you some ideas. You could try to get the demo version of phdBase in order to use and test the form.

HTH
>I have an old program called 'Friendly Finder' made by Proximity in 1991. Of course the program is outdated and won't recognize VFP tables without converting them to Foxpro 2.6 dbfs. This program would open a table and allow searching any field or multiple fields in the table with 'fuzzy' logic. ie. you would type the letters 'GRE' and anyplace in that field where 'GRE' was present the records were displayed in the grid below. Is anyone aware of a product like this that is available? I developed something similar with SQL but it just doesn't have the same speed nor the fuzzy logic.