Here's some odd behavior that I cannot figure an explanation. I set up a query (custom view) utilizing three conventional tables, nothing complicated. They are all connected by simple inner joins. I use the query to list records of a table called "tblcasereps" There are two search buttons to utilize on the page of course, one at the top named "simple_search" on the designer page and the other along the left border, "search_panel," the latter offering to show the fields that can be used to search. Here is the strange behavior.
When I use the simple_search method on top, I get an error message, if just for a few seconds: Unknown column 'tblcasereps.CaseNo' in 'on clause'
The error starts when I start to type in the search word at the top search method box, in this case a client's or customer's last name in order to focus down the list. The query still works without disturbing the search by the way, it just passes by it not disturbing the search but a moment. In fact, if I type the search word fast enough, the error message doesn't even have time to appear. Again, the search is otherwise flawless and works fine.
Now, if I utilize the left side "search_panel" button the error never appears, it just works without being bothered. I can type the very same search word very slow and no error. I have tried various ways to correct the error on the simple_search button, but each time I correct the error it cause something else to not work right in other areas of the project, so I have not figured it out, yet that is.
Also, if I invoke "Advanced" search with all of it's flexibility, it too works without error the same as the left panel filtered search button.
My question is why does the top search button produce an error notification and the other search button does not? What is the difference between the two search buttons? I cannot find an explanation through the help system or I have not yet. Any ideas?
Randy J
