How to filter the record using a drop down list

[Simple Juan]

Hello everyone,

I have bee browsing the forum trying to figure out what do I need to do to accomplish this.

I just want to use a multiple dropdown list to display records that is based on the dropdown selected. For example,I want show records from canada, I will select canada from the dropdown and FM will display all records that have Canada as country.

Thank you for your time.

[Inky Phil]

Create a global field 'selector'

Establish a relationship between this field and your country field.

Create a value list that shows all values from your country field.

In layout mode set up the global field to be a drop down list based on the new value list. This will allow you to select the country that you want. Then create a portal that displays records from the relationship that you created between the global and the country field.

Whenever you select a new country from the list only it's records will show up in the portal.

HTH

Phil

[Simple Juan]

Hi Phil,

Thanks for this reply. I will try it right away and let you know the results.

Thanks again!!!

Create a global field 'selector'

Establish a relationship between this field and your country field.

Create a value list that shows all values from your country field.

In layout mode set up the global field to be a drop down list based on the new value list. This will allow you to select the country that you want. Then create a portal that displays records from the relationship that you created between the global and the country field.

Whenever you select a new country from the list only it's records will show up in the portal.

HTH

Phil