Jump to content

How to filter the record using a drop down list


This topic is 6097 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • Newbies

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

Link to comment
Share on other sites

This topic is 6097 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.