Dummy Questions

[ck]

Greeting!

I am a beginner in developing FileMake Pro Database. This is my first database and I get stuck when I try to implement the search function.

1. There's a field called "Salary". I would like to let the user to type in the minimum and maximum salary and return the related records in the result page by pressing a button. What should I include in the scipt?

2. In the same layout, I would like to include other fields for search as well, e.g.

Name

Language

Position

But I would like to make the search "Name" OR " Language" OR "Position", How can I do it?

Thanks in advance.

[stanley]

For the salary question, that's pretty simple. The syntax for the request is "...", meaning that if you want all salaries between 10,000 and 50,000, you would enter "10000...50000" in find mode in the salary field. That's not pretty, and users never remember that sort of thing, so what you can do instead is to create a special layout for the user's search, in which you've got two global fields, "MinSalary" and "MaxSalary". When the user clicks the "search" button you can script the search to:

1. enter find mode

2. enter the calculation MinSalary & "..." & MaxSalary into the "Salary" field

3. perform the find

(along with whatever else, error correction, etc.)

As for the second part, you could have another global field called "AltSearch" or something, which is where the user could enter Name, Language or Position. Another field, called "SearchType" would be laid out as radio buttons, where the user could pick if the data they typed in was Name, Language or Position. The scripted find (once again, when the user clicks the "search" button, or however you arrange it) would then if/then through the options, pick up what the radio button was set to, then apply the text in "AltSearch" to the correct field, perform the find, and return the results.

Hope that's useful

-Stanley

[stanley]

I realize I wasn't totally clear about MinSalary and MaxSalary. They'd be fields the user could type in - you'd label them as "Enter your minimum salary" and "Enter your maximum salary."

-Stanley

[ck]

It works perfectly. Thanks for your help!