Subject Re: How to calulate field value in a Grid? From Milind Nighojkar <milinigh@yahoo.com> Date Fri, 30 Jul 2021 10:42:01 -0400 Newsgroups dbase.getting-started Thanks for the reply Akshat, Aging and Estimated Field both are table fields... I am not aware how to add calulated fields in grid ..... Any pointer what could be the code on Lost focus ? Regards Milind Nighojkar Akshat Kapoor Wrote: > Good Evening Milind, > > > I have a calulated field in a grid. > > Scenerio : > > Field \'Aging\' which is calulated based on Date() - 'Estimated_Date' > > How to calulated Aging in a Grid Form when it opens and when 'Estimated_Date' is changed > > First issue how is Aging calculated. Is it a calculated field or a field > from table. > > If a calculated field then it will be changed automatically. > If from table then check the next point. > > (If it is a calculated field then the rowset will probably be readonly) > > > How is Estimated_date changed. > > If it is in grid then I have no idea. Never did such programming for > editing in Grid. > > If  you are changing in entryfield then use the onLostFocus event of the > entryfield to change the value. > > Regards > Akshat