VFXdbGuy Posted January 20, 2005 Share Posted January 20, 2005 I have two tables: parent and child. Parent fields include Price ExchangeRate Child fields include Quantity ChildExchangeRate ExchangeRateUsed (conditional: Parent::ExchangeRate unless ChildExchangeRate contains value) Cost (Price * Quantity) USCost (Price * Quantity * ExchangeRateUsed) This arrangement is needed as quotes are often spread out in time. Most of the items are culculated using the Parent ExchangeRate but the ones done later may require a different rate. Global fields are out as I need the Parent::ExchangeRate to stick whle the file is hosted. This all works well at the Child record level, until I create a Summary field in the Child table that adds up the USCost for all the Child records. This value refuses to update until a Child record changes. I need this calculated for the Child records as I need the total to reflect the values of the Child records in the current found set. Am I hooped? Link to comment Share on other sites More sharing options...
This topic is 6634 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now