How to prevent recalculation?

[Cin]

I'm not sure how to ask this question.

I have a form where I muliply hours by employee rate. My rate field is in a separate database. The rates change each year. How do I prevent the current year's information from changing?

Cin

[Mike D.]

You can do this by using an auto entry look up. In the hours file, have a rate field that is an auto entry using a look up from the rate field other database. You can then change the rates in the other database without effecting the historical calculation in your hours file, only new entries will reflect the updated hourly rate.

HTH, Mike

[Cin]

Mike,

Thank you for your help. I tested it and it works!

Cin