Search for a Variable in any Field

[Joseph31]

Hello everyone,

I have two fields: FirstName & LastName

I can do a normal search, but what I would like to do is to beable to search for a name in both fields at one. ie: Ruth Chris well some one might put that person in the system with the first name being Chris not Ruth.

Is there a way to make a script on a search that will search for any occurance of Chris?

Thank you

[Fitch]

There are a couple of approaches you might use. Here is a fairly simple one: first, take the user to a layout that has a global field on it, and a button attached to a script, and the script would look something like this...

Enter Find Mode

Set Field( NameLast, yourGlobalField )

New request

Set Field( NameFirst, yourGlobalField )

Perform Find

[Joseph31]

Ok, so does this look correct?

Enter Find Mode [Pause]

Set Field [File_login::Login_LastName; File_Login_Welcome_Page::Login_Search_Field]

New Record/Request

Set Field [File_login::Login_FirstName; File_Login_Welcome_Page::Login_Search_Field]

Perform Find[]

The Welcome page has the gobal field on it with a button with this script but it does not work?

Please explain

[Fitch]

Take out the Pause in the first step. Also make sure that both the first or last step leave the Restore option UNchecked.