I have portal records where the link is ID. But the status of the
records could be active or complete. I get all records including
Active and Complete because ID is the link. But I only want to show
Active. How do you tell a portal to use a search criteria ?

-S

<squeed2000 (AT) yahoo (DOT) com> wrote:

In FM 7, create a global field in the data table, and put it on the
layout. Populate it with the Active data, whether that's the word
"Active" or a number such as 1, used as a flag.

Now, your relationship can have TWO predicates. One where the

ID = ID
and the second, where
Global = Status

Do this in the relationship editing dialog box.

Only active records will show in the portal. If you change the global
data, your portal display will change. You can see that if you set it to
"Inactive" it will show inactive records. Play with using a value list
on that global field, or setting the relationship to "Less than or equal
to" which should show all records, active or not, when "Inactive" is
selected in the global.