Easiest way to filter records?

[HPage]

I have list of people with their current employers. At the top of the list I have a pop up box (Field: EmployFilter, global value I suppose?) with all the employers names. How can I tell filemaker to only show the employees of the company that I selected in the popup box?

Help would be appreciated, thanks :

[mr_vodka]

Is it in a portal or List View?

If the records display in a portal, you can just have it display the relationhip with the keys beign from your global selection field to the employers field.

If you are using list view, you can use a find or Go to Related Records.

[HPage]

It is in list view, sorry I am a beginner, could you please explain how I should use Go to Related record? Thanks for the help!

[mr_vodka]

Go To Related Records allow for going from a parent record to child records using a layout that displays the child records.

If you are trying to go to records from the same table as your data from your list view, then I would recommend just scripting a find with at button.

Have your global field gEmployerSelect in the header section of the list. You can have this global field have an attached value list that displays all the employer names. Then just do a simple find script that is envoked with a button.

Set Error Capture [On]

Enter Find Mode []

Set Field [Employer; gEmployerSelect]

Perform Find []