Compare attritbutes

[christopherb]

There is something i'm missing here... here's the scenario

3 Objects
Customer (parent)
Invoice (Child)
YrTotals (Child)

Simple in the fact that a customer has an invoice and yearly totals are kept in the YrTotals for all of a customers invoices. Here is a rule in questions on the customer OB;

BookSalesCustomer.YearTotals.TotalBooksOrdered=SUM BookSalesInvoice.InvoiceOrderQty WHERE (BookSalesInvoice IN BookSalesCustomer.Invoice)

This all works fine for testing but of course it would update every instance in the YrTotal BO. So lets as some conditions in. And this is where the trouble comes in. I have tried to match the year attribute of the Invoice BO to match the year attribute of the Yr Total BO, such as;

BookSalesCustomer.YearTotals.TotalBooksOrdered=SUM BookSalesInvoice.InvoiceOrderQty WHERE (BookSalesInvoice IN BookSalesCustomer.Invoice AND BookSalesInvoice.Year=YrBookSales.Year)

But with trying even several syntax changes I can't get this to work. I am missing something really dumb i'm sure.

Chris

[tford]

This rule on YearTotals should take care of it:

YearTotals.Amount=SUM Invoice.Amount WHERE (Invoice.Customer=YearTotals.Customer AND Invoice.Yr=YearTotals.Yr)

Tom