Subject Re: Property not getting set in Form using query From Akshat Kapoor <akshat.kapoor@kapoorsons.in> Date Mon, 5 Jul 2021 22:24:51 +0530 Newsgroups dbase.getting-started Attachment(s) news group settings.pdf, Screenshot 2021-07-05 222155.jpg 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