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 July 26, 20196 yr by Gilbert13

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

Thank you so much for teaching me a better way.