yafreax Posted February 28, 2005 Share Posted February 28, 2005 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 More sharing options...
-Queue- Posted February 28, 2005 Share Posted February 28, 2005 In your Clients table, create a calculation text field of ClientType & Link to comment Share on other sites More sharing options...
yafreax Posted March 4, 2005 Author Share Posted March 4, 2005 Queue, Thanks for the response. I tried creating what you are talking about, but it's not working. Can you (or anyone) take a look at this scaled down file (FM7) and see what i'm doing wrong? Thanks Jeremy selfjoinprob.zip Link to comment Share on other sites More sharing options...
-Queue- Posted March 4, 2005 Share Posted March 4, 2005 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 More sharing options...
yafreax Posted March 7, 2005 Author Share Posted March 7, 2005 thanks for clearing things up. works fine now. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now