Matching empty fields

[Moe]

Hi,

I have 2 tables with the following relationship:

globals::cities = camps::cities

If I put 'springfield' in globals::cities, all the camps that are located in springfield appear in a 'camps' portal, which is beautiful.

The problem is this: a lot of camps records don't have a city entered. The field is left blank. How can I make those records appear in the portal?

Thanks,

Moses

[mr_vodka]

You can try and create a calc field and use that to match instead.

IOW,

If (Trim ( IsEmpty ( city )) ; 1 ; city )

then you can pick a calc field for the global value too. When they are empty they will match on 1, else they will match on the city name.

[Moe]

I tried that, but for some reason I don't get any matches unless I change the relationship from = to x.

[mr_vodka]

Make sure that your calculation for you global field is a global calculation.