Hello, I have a parent table (students) with a portal that displays records from the related table (courses).

There is a portal on the Students layout that is based on two criteria:

1) (the very common) foreign key to primary key

AND

2) a global field in the Students table that allows the user to see only filter to display only records that are type "A" or type "B".

This works just fine and the filtering works as expected in the portal. However, when the user sets that global field to set the relationship to show only one type of record (e.g. type "B") and then does a search it returns a found set that includes Students with only type "A" records, and the portal is empty (which it should be). I don't want the search to return students with empty portals.

Does the filter not work in find mode? Any insights are appreciated. Thanks so much!

The problem is the global field, which cannot be set during the find procedure.

How about scripting it so the user can specify "A" or "B" (in a dialog box) immediately after the find has performed.

Okay, good that it's comfirmed that globals dont work in find mode. Thanks!

What would happen after the user selects A or B? In other words, what comes after the If Get(LastMessageChoice) script step?

Thanks for your help!