Subject Re: Property not getting set in Form using query From Milind Nighojkar <milinigh@yahoo.com> Date Wed, 07 Jul 2021 11:09:31 -0400 Newsgroups dbase.getting-started Hi Akshat, Thanks for the reply on the help I asked It was pleasure to learn that you are from Prayagraj. Can we connect..? Your mail id mails are getting bounced Regards Milind Nighojkar Akshat Kapoor Wrote: > Good Evening Milind, > I am from Prayagraj. > > > Ashat Yes  am from Pune > > > > Screen shots are added > > You can attach screenshots as jpg itself. > Not many people will open .docx > > Two recommendations > 1. Go through Ken's tutorial. It is a must I would say > 2. Opt in for newsgroup reader to read the replies to your post. > Instructions are attached in pdf > > Now coming to your problem > > The query you are using is > > Select todolist.*,  rec_status.* From todolist   Inner Join rec_status > On todolist.Status_id = rec_status.Rec_Status_id > > The query is important the screenshots of achieving it is not important. > The screenshots of inspector would have been better in informing which > property is creating issues. > > The moment you use 2 tables or use an order by clause with multiple > fields the rowset becomes readonly. > > i.e. you cannot modify it. > > This is the root cause for you not being able to adjust the modified > property of the rowset as the row cannot be modified. > > This property is changed automatically by dbase to indicate if any of > the values have changed or not. > > Hence It is never changed by the programmer. Just its value is checked > to see if there are any modifications. > > Have you just started with dbase or inherited a legacy program. > > Regards > Akshat >