I've been playing around with filtering portals using the "all" option.

Two tables, a one and a many (say client and invoices).

In the invoices basically I create globals

g_1

g_2

etc

then I create calc fields that are

1_calc= If (g_1 is empty, "all", g_1)

2_calc= If (g_2 is empty, "all", g_2)

etc

then I create field calcs

field_1=field & "¶" & "all"

Then I relate

1_calc to field_1

and 2_calc to field_2

and etc

Now I have a portal with all the g_n's at the top as dropdowns and by selecting or clearing fields it filters the portal by what's showing and what's not in the globals. So I can filter by date, etc. in the invoice file.

All fine and well... as long as all the fields are in the current table.

The problem is I'd like to also filter some items that exist in the client table but if I create a calc field in the invoice that is the value of the field in the client the relationship never works.

I might like to filter out by city and invoice date.

My guess is it has something to do with indexing but I'm not smart enough to figure it out.

Any suggestions?

Thanks,

R

here's an example.

filter.fp7.zip

shoot, here's the one with the filter and filter not working.

filter.fp7.zip

I just saw in here a better way to make the calc's instead of what I was doing (all the fields), atsa nice! However my problem still is the same.