Here is another periodic error with screen shots of the searches and incorrect results they provide.

I do a search for a price range and a city. The city is the issue. The name of the City is "IRA". If I search for "IRA" I get no matches. If I search for "IR" I receive 126 matches including [color:red]IRA and St. Cla[color:red]ire and B[color:red]irmingham

Again this is Periodically, not all the time. This error was with Safari on a Mac. I immediately opened firefox and performed the same search and received the correct results with 14 matches.

This is DB with 27,000 real estate listings. Created with Site assistant and modified a little. I have redeployed and started from scratch too many times to count.

Link to Screen Shots of the incorrect results

Thanks

Site link:

Link to the Site www.MLSMAX.com

Does your database contain a referenced file? For me, it appears that even if the referenced file has the same permissions, when the calculations go to that referenced file, they don't always work. I semi-solved my issue by simply creating a lookup field when the record is created. It's not perfect because of obvious reasons, but our data in the referenced file won't change that often if at all.

That's strange with the Firefox/Safari issue. I believe mine didn't work on either, but not positive on that. I'm developing using Safari, and checking occasionally in FF.

Thats the bad part. This is a 1 table 1 file solution. It can not get any simpler.