How can I find a single term across multiple fields
Hi. I'm new to FM. I have an old database in Microsoft Works. The database was written by someone else and keywords one might use to search with may (or may not) be in any one of four fields. While Works is as old as the hills and clunky in many ways, the one great thing for my purposes is that I can type in a search term, click 'All records' and it will find and bring up all the records with that term whatever the field is.
I cannot see a simple way of doing this in FM. I have to type the term in one field, search, then do it again in another field etc.
Any ideas, anyone?