Jump to content

Need help with portal


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

Recommended Posts

Hi,

I have two related tables in my file, I want the portal to display related records wend "g_Color" or "g_Type" fields are empty. I know the relationship parameters in g_Color and g_Type are wrong for my purpose, but I don't know how they should be.

Home:ID_Key = Cars:ID_Key

Home:g_Type = Cars:Type

Home:g_Color = Cars:Color

 

Thanks in advance...

Portal_filter.fmp12

Edited by Gilbert13
Link to comment
Share on other sites

48 minutes ago, Gilbert13 said:

I want the portal to display related records wend "g_Color" or "g_Type" fields are empty.

Did you mean "I want the portal to display all related records when "g_Color" or "g_Type" fields are empty"?

An empty match field will never have any related records. If you want to filter the relationship using global fields like that, you will need to add a calculation field for each global and have it return a list of all values when the corresponding global field is empty. Then use these calculation fields as the match fields instead of the globals.

Alternatively, you could filter the portal itself instead of the underlying relationship. This is much simpler (see the attached demo), but it can get slow if the number of related records is large. 

 

Portal_filter+.fmp12

Link to comment
Share on other sites

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