AnsweredAssumed Answered

Automating Recalculation

Question asked by ninja on Jul 6, 2009
Latest reply on Jul 7, 2009 by ninja

Title

Automating Recalculation

Post

Howdy all,

 

Environment:

PC-XP,SP3

FMP8 (ie. no script triggers)

Chance of upgrade to FMP10 for a ~40+ license facility in this economy = 0%

 

I'm looking for a way to update a calculated field automatically...most do, but I seem to have found one that doesn't.

 

Batch Table: has batch data including total percent volatile per the spec.

Ingredients Table: related many to one (many ingredients, one batch).  Has "% of batch" field among others.

 

On Ingredient, it is either volatile or not.  If so, and if the total starting %volatile doesn't match the %volatile on the spec, the %final in batch is shifted (by calculation) on each ingredient so that %volatile matches the spec.

 

All of this works perfectly.  Now the problem:

% volatile is in the Batch Table (parent)

The calculation to adjust batch% based on volatiles is in the Ingredient table (child)

The final calc I need is in the batch table (parent) and uses the "revisedbatch%" calculated in the child table.

 

If I change the starting % of an ingredient (in the child table), everything updates fine automatically.

If I change the %volatiles on the spec, it doesn't update the child table calc. thus doesn't change the final calc on the parent table.  I figure that this happens since my layout is based on the parent table.

 

If I go to the next record and back, eveything has updated AOK...how can I get it to update without doing that?

Right now I have a "recalculate" button that goes to another record and then back.  A definite patch-around.  Is there a way that isn't occurring to me to automate this recalculation?  I don't need a better way to script the "refresh", I'd rather not have to hit the button in the first place...it's too easy to forget...and then the final calc shows wrong data.

I would use a script trigger...if I had one.

 

Any ideas?  Did I explain well enough?

Outcomes