Relationship using calculated and looked up values

[backsmith]

Hi

I would like to build a relationship to populate a portal where.

Customer Invoice

Cust_pk = cust_fk

g_zero < amount outstanding

where g_zero is a global = 0

I cant use a calculation in the relationship because I get the amount ourstanding from another table.

Invoice Allocations

invoice_pk = invoice_fk

amt_outstanding =

invoice total - sum(allocations::invoice total)

I can make this work by doing the calculation and setting a separate field with fixed results (either the amount outstanding or a calculated cust_key.

I am thinking there must be a more elegant way to solve this display of part paid or unpaid invoices in a portal.

Thanks

John

Edited December 18, 2009 by Guest