Jump to content

raygeeknyc

Newbies
  • Posts

    3
  • Joined

  • Last visited

Everything posted by raygeeknyc

  1. MegaThanks , a picture is worth a kiloword! (it does)
  2. 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
×
×
  • Create New...

Important Information

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