February 28, 200817 yr Is there a way to do a sort of general search where you can search all fields with one request? It was possible in the old Apple Works database. A simple Find window and it searched all available Fields for the query. Thanks, Erik FM dev 7
February 29, 200817 yr an ugly way to do this would be to create a single field that is a join of all the fields you want to search on. That is Search Field = & " " & & " " & and so on. If there is a lot of fields and a big database, be careful of a huge file size increase and also be sure not to build it with unstored index fields. Search will be very slow. The only other way would be to script a find so that the criteria is added to a new find request for each separate field. Quite painful to create and maintain it though
Create an account or sign in to comment