Hi all,

I have to carry out a global search in Filemaker6 database.

I have a table with 10 different fields but I want to create a new form with a text field where the user can input some free text that will be search in all fields of the table to return any values if they are in the database.

Can anybody help me?

Regards

I think you can do something like this:

Copy (G_Search)

Enter Find Mode

Paste (Field1)

New Record Request

Paste (Field 2)

.......

Perform Find

Thanh is essentially correct, but instead of copy/paste, you should use Set Field[], whereby you can set the fields to be searched via the global. The reason it's better to use Set Field[] is that copy/paste will populate the clipboard and, even worse, if the global is empty, it will use whatever was already in the clipboard as your search criteria.

-Stanley

You can look at the following post:

http://fmforums.com/forum/showtopic.php?tid/170493/