Hi,

I have a list of users with there Name ,phone number and email. I have a "status" field wich have to be enter using a value list. The Values are "Freelancer" ,"Permanent", "Away", "Standby".

When a users are looking for somebody email or phone number they make a search by "Name".

Now, I want the result to display only the ones that are "Freelancer" or "permanent", when people make a search.

How can i make this happen using a script or a calculation ?

thx

guy

One way to do it is use the Perform Find script action.

add the script action and dbl click on the line, it should display a dialog.

click the new button, and add a find.

pick the table you want to find on from the drop down.

type for Criteria "Freelancer" (no quotes); click Add.

now add another line by doing the same thing again, but instead type "permanent"

save the script.

to do a simple test, create a layout with the table you want to search (must be same table as the table you picked from the drop down list when adding the 'finds' to the find script.

pick from the scripts menu the script you created.

(put the layout in table view)

and you should see the matches for Freelancer or permanent.

hope that does the trick.

sincerely,

J__