Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

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

Recommended Posts

  • Newbies
Posted

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!

Posted

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.

  • Newbies
Posted

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!

This topic is 5849 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.