Hi,

For the most part when I do a search/find, I use the find button which blanks out all the fields, then the user can enter any data they want. It works well, but I wanted to make it look more professional. What I wanted to do is when a person wants to do a search they would press a button which opens a window, then the fields would be blank, (possibly arragned in a more compact fashion). once they have entered their search terms, it would search, if results are found it would transfer that found record into the intial form they were searching for.)

The other questions is how do you perform a wildcard search without the end user mannually entering a wildcard character?

Finally, what's the easiest way to script a solution if there are no results found...?

Thanks Vandy

Well, my search routines usually look like this:

Go to Layout [ Find ]

Enter Find Mode []

Set Field [ SomeField; <DefaultValue> ]

Pause Script [ Indefinately ]

Set Error Capture [ On ]

Perform Find []

If [ Get(LastError) = 401 ]

   Custom Dialog [ "Message"; "No records found." ]

   Go to Layout [ original layout ]

   Show All Records

   Exit Script

End If

Go to Layout [ List View ]

The Find screen would have a button to Resume the script after search criteria is entered.

I'm not sure how you would modify it to fit into a multi-window solution. I suppose you could use one window for the search and results list, and the second for the detail view. This way the list stays up in one window, while the detail is up in the other.

I think we'll need a bit more about what you are looking for with your 'wildcard search'. Are you saying you always want to find only those records where a particular field is not empty or something else?