Searching All Fields

[leomark]

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

[Adrian Simpson]

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