Hi,

I don't know much about filemaker and need help creating a script.

I want to create a report of current employees and their departments and phone numbers.

I have created a layout that I want to show this information in.

I have a field called 'current employee,' whose value is either 'yes' or 'no.' How do i create a script that only shows records that has a 'yes' for this value?

thanks.

scotty, just trigger a search for employee=yes and print out the result. is recomending: someguy

hi Scotty and Phonoguy

If you want to create a script or script to do this in the future,

FileMaker remembers your last "Page Setup", "Import Order", "Find Request", "Sort Order", and "Export Order". So, First perform the Find and the Print steps manually, get them exactly the way you want them, and then create a script using the steps in it.

You can use these steps in a single script, or make them individual scripts for use as subscript scripts so that they can be used for other needs such as to Print a report using a different criteria (i.e. "No"), or use the Find for just viewing or using the group in Browse mode. In any case, be sure to Name your Scripts so that they makes sense to you (and others) with enough information so that in the future you know what the script does. Another Script Step that helps in this regard is the Comment Step which you can then comment about the script or a step in the script to help for better recall of what the script step does (i.e. Comment: "Script finds All Current Employees").

HTH

Lee