using IIF expression to decide what formula to use for the field?

From: Gareth (Gareth_at_discussions.microsoft.com)
Date: 12/26/04

  • Next message: Matt Neerincx [MS]: "Re: Recordset.AddNew and the recordset object's data retaining" 
    Date: Sun, 26 Dec 2004 08:27:05 -0800

    Hi,
    I want a datacolumn expression which will work out a value depending on the
    value of child records here is the expression that does not work. if any1 can
    help me that would be great

    iif(child(Packaging).CasingFlag =
    'Y',Sum(child(Packaging).PackagingCostPerKg) *
    parent(ProductProductVariant).NetWeight,Sum(child(Packaging).PackagingCostPerKg) * parent(ProductProductVariant).GrossWeight)

    also is it possible to refernce a chile or parent value through multiple
    relationships?
    thanks

  • Next message: Matt Neerincx [MS]: "Re: Recordset.AddNew and the recordset object's data retaining"