Filtering

[jbullydawg]

We have a Registrant table and a Program table in our non-credit database and I'm having an issue trying to filer the list of registrants in the portal that resides on the Program layout.

Each registrant in the Registrant table has a status within the program; Active, Completed, or Cancelled.

The Program table contains a portal displaying all those that have registered for the program.

I would like to filter the portal out to only display those registrants that are listed as Active in the Registrants table and I'm not sure how to do that...if it's even possible.

Thoughts? And sorry for the newbie question.

Thank you.

[Breezer]

It is quite possible, infact there' plenty of threads addressing this issue:

Follow these links:

http://fmforums.com/forum/showtopic.php?tid/192202/post/276524/hl/filter/fromsearch/1/#276524

You can also be creative and use a drop-down list by using comment's suggestion from this post:

http://fmforums.com/forum/showtopic.php?tid/193018/post/280309/hl//fromsearch/1/#280309

Portal_Filter.zip

Edited February 8, 2008 by Guest