Account -> Order -> Product portal help

[raygeeknyc]

Hi

I have a problem getting a portal to filter properly.

I have, for purpose of this discussion, 3 tables

Account <- Order -> Product

Accounts have Orders

Orders are for Products

Products have Product Types

Product has globals for each Type

for example "TYPE_SUBSCRIPTION = 'Newsletter'"

Accounts have Account IDs and calculation fields that represent each Product Type.

For example there is a field "Account::TYPE_SUBSCRIPTION" set to "Product::TYPE_SUBSCRIPTION"

This is done via a "1" = "1" relationship to Product

Orders have account IDs and Product IDs

Products have Product IDs and Product Types

I wish to add a portal to Account that shows all Orders for that account for a given Product Type.

I set the portal to view records from the relationship "Subscriptions"

1) I defined relationship Subscriptions as "Account:account_id = Order:account_id" and it shows the orders and the correct product types in the portal

2) If I then add "Account::TYPE_SUBSCRIPTION = Order::Product_Type" nothing is shown in the portal.

3) If I reduce the relationship to just the Type field constraint ("Account::TYPE_SUBSCRIPTION = Order::Product_Type") without the account_id, still nothing is shown.

So close... but I cannot figure out what is wrong.

All help greatly appreciated.

If rather than debug this, someone has an example or explanation on how to have a view that shows the Orders of a given type when the order's type is itself a reference to a related table on Order that would be just as welcome.

Thanks

[comment]

This is rather difficult to explain, so see if the attached helps.

FilterByUnstored4.fp7.zip

[raygeeknyc]

MegaThanks , a picture is worth a kiloword!

(it does)

[comment]

LOL, I recall a while back someone made a calculation like:

One picture (at VGA resolution of 640x480 pixels, 256 colors)

640 * 480

= 307,200 pixels

307,200 * 8 bits

= 2,457,600 bits

Average word (in English, including a trailing space or other punctuation)

5.5 characters * 6 bits

= 33 bits

2,457,600 / 33

= 74,473

Therefore, one picture is actually worth 74,473 words.

Of course, today's pictures are much more richer in resolution and color, so the equivalent of a 1024×768 full color picture would be close to half a million words.

[raygeeknyc]

Priceless!