We have define a BO the has 3 levels in it, The BO's are:
Budget:
Description Text
LevelNumber Number Values 1 thru 3
Amount
Children link back to Budget with Muiltiples allowed
When we update the amount on level 3 we need to roll that change up to the level 1 and 2 budgets
Our rule is as follows:
If Budget.Amount WAS CHANGED Then
FIND Budget WHERE Budget.Children=ThisBudget IN BATCHES OF 1
Budget.Amount=Budget.Amount-OLD_VALUE(ThisBudget.Amount)+ThisBudget.Amount
What it is doing is as follows:
- It is updateing the level 3 record for a second time
- It the update the related level 2 record which is fine
- At this point we expect an update on the level 1 row but what its doing is find the level 3 record again and update it causing and infinite loop between Level 2 and level 3 again and again....
We asume our find is wrong but can't think of another way to right it.
Any Thoughts?
