Filter Records in Layout Using Script

[emcclure]

I have an employee database that shows records for three different types of employees. I'm trying to create a script that shows a list of each employee type on different layouts. Scripts are not my strong point and any help would be greatly appreciated.

[Matthew F]

My suggestion is that you do this with a relationship and not a script step. See the attached example.

Employees.fp7.zip

[comment]

I'm trying to create a script that shows a list of each employee type on different layouts.

Try:

If [ IsEmpty ( Get ( ScriptParameter ) ) ] 

Show All Records 

Else 

Enter Find Mode [  ] 

Set Field [ Employees::Type ; Get ( ScriptParameter ) ] 

Perform Find [  ] 

End If 

Set each layout to perform this script OnLayoutEnter, with the appropriate type as the script parameter.

Note that this is necessary only if you have different layout requirements for each type e.g. type-specific fields. Otherwise you could just perform a find within the same layout.

[emcclure]

Thanks so much! The script worked great!!