Welcome. I am asking you very much. Have any of you met with an example of a similar text search engine in many tables in an open office? generally, it does not even have to indicate in which table, column etc. as in the attached example. All they need to do is search and display a row with the searched text or part of it found in one of the tables. thanks in advance for any help or advice on how to do it yourself
link text
Hello,
In order to search all tables and all fields for matching text you would need to write some type of macro.
This could become quite involved as you need to get the varying number of columns and tables.