2 Replies Latest reply on Nov 4, 2010 1:02 PM by mgxdigital

    Portal Help

    mgxdigital

      Title

      Portal Help

      Post

      Hi everyone,.

      I'm having trouble with a relationship that relates to one of my portals.

      I have a layout with a calculation field:

      Orders_Cost     Calculation     = "0"

      And another layout with a calculation field that i'm relating to the Orders_Cost

      Sheet Cost_Total    Calulation    = Sum(Order Line_Cost)

      I'm trying to relate these 2 fields so show orders in a portal with zero cost, and in another portal with cost.

      One of my relationships is Orders_Cost < Sum(Order Line_Cost). This would be the portal to show any order where the cost is higher than Orders_Cost (which is Zero).

      This relationship is not working.....

      BUT....i texted this same wording via Conditional Formatting and it worked.

      My Conditional Format was on the Sheet Cost_Total field and was a formula where Self>Orders_Cost...

      This worked perfectly..but i can not get it to work with relationships!!

      Please help!

        • 1. Re: Portal Help
          philmodjunk

          Are you sure you've entered this correctly?  Sum(Order Line_Cost) or should this be:  Sum ( Order::Line_Cost ) ?

          If you meant the second version, calculations that refer to fields in a related table are by defnition unstored and unindexed. Unindexed fields cannot be used as key fields on the child side of a relationship. Thus, what you have set up will not work. Conditional formatting expressions and portal filters (FileMaker 11) do not have this limitation.

          If you have FileMaker 11, I'd just use this expression in a portal filter instead of trying to define it in the relationship.

          In older versions, you'll probably need to use a script to store the order total in an indexed field. In our invoicing system, we do that by saving the invoice total in an indexed invoice field in a script that the cashier uses to print the invoice. We do that so that we can perform quicker invoice total based searches of our invoices, but it would also work for your portal.

          • 2. Re: Portal Help
            mgxdigital

            Portal Filter worked great. Just some of the older Filemaker 10 users will not be able to use this correctly. But it will work for now!

            THANKS SO MUCH!!