Jump to content

Portal Filter Issue


yafreax

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

Recommended Posts

In a Client System i have a Field: ClientType which can be set to "Potential", "Active", or "Inactive"

From my main entry system, i like to use X join portals to show all the available records for any given system. In this client system i would like the portal to show any given set: All Potential, All Active, or All Inactive (no problem so far)... or SHOW ALL.

That's where i hit my snag. Theorhetically i can think of a solution using three extra fields, but it seems messy and it uses calc fields as join fields which sometimes give me issues (I get the "relationship won't work" message alot when calc joins are involved...).

Any solution ideas? or if i didn't explain it enough, please let me know.

Thanks in advance.

Jeremy

Link to comment
Share on other sites

The relationship should be from g_UserType to c_ClientTypeFilter. c_ClientTypeFilter must be indexed (if it's unstored, it cannot be used as a key) and should be a calc of ClientType & "

Link to comment
Share on other sites

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