Dynamic Calculations

[George Rozakis]

Hi. 

I have a single field, call it LETTER, with a massive calculation, but I want that calculation to be vary depending on another variable, ie a person. (Tom, George, Pete, ... ).  So I"m thinking I need a table of a calculation for each person.  Tom and his calculation, George and his calculation, etc , But how do I get those different calculations into the LETTER field.  Is it a lookup command?  

Appreciate any help.

George

 

 

[doughemi]

How different is the calculation for each person?

From the name of your field, I can conjecture that you are creating a semi-form letter. Can it be broken down into parts that are boilerplate and parts that are personalized?

Much more information is required to give you an answer.