Check whether all records have the same field entry

I have the three tables in FMP 8:

Orders::orderSNR

Items::orderSNR
Items::InvoiceSNR

Invoices::Invoice SNR

When printing an invoice, I need to know whether all its items have the
same order::SNR (I need to go to a different print layout if this is not
the case).

The quickest thing I came up with is to check:
average(items::orderSNR) = items::OrderSNR
--
http://clk.ch

In article <1iltj1x.102casb1t08w5iN%clk@tele2.ch>, clk.RemoveThis@tele2.ch
(Christoph Kaufmann) wrote:

> I have the three tables in FMP 8:
>
> Orders::orderSNR
>
> Items::orderSNR
> Items::InvoiceSNR
>
> Invoices::Invoice SNR
>
> When printing an invoice, I need to know whether all its items have the
> same order::SNR (I need to go to a different print layout if this is not
> the case).
>
> The quickest thing I came up with is to check:
> average(items::orderSNR) = items::OrderSNR

As long as OrderSNR is an actual number (ie. not something like
"Mag_06_2008") that should work fine, and is probably the easiest way
to do it.

If it works, why try to fix it? )

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)