Jump to content

Filtering Portals


ricardito
 Share

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

Recommended Posts

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

Link to comment
Share on other sites

This topic is 5674 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
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.