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

In your Clients table, create a calculation text field of ClientType &

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

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 & "

thanks for clearing things up. works fine now.