https://www.infopathdev.com:443/forums/44.aspx enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/50632.aspxFri, 15 Jan 2010 09:21:18 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:50632Qazi Anis0https://www.infopathdev.com:443/forums/thread/50632.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=50632<p>in infopath template create a field say leaseRate2 and set it to recieve its value from the data connection (i.e. the original lease rate) . and in the properties of leaseRate2 uncheck update this value when the result of the formula is recalculated</p>https://www.infopathdev.com:443/forums/thread/50616.aspxThu, 14 Jan 2010 19:36:42 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:50616AgTxTech0https://www.infopathdev.com:443/forums/thread/50616.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=50616<p>We have an InfoPath template that obtains a vehicle lease rate from an employee list database.&nbsp; When an employee obtains a new vehicle&nbsp;we have to change the lease rate to reflect the new lease cost.&nbsp;&nbsp; When we update the database lease rate, all existing mileage reports, stored in a SharePoint library from prior months and years, automatically update to reflect the new lease rate.&nbsp;&nbsp; We want old reports to retain the original lease rates, while subsequent reports reflect the new lease rate.&nbsp;&nbsp; How do we retain the original calcullated results on old filed mileage reports.</p> <p>Thanks.</p> <p>&nbsp;AgTxTech</p>