Subject Re: Property not getting set in Form using query From Mervyn Bick <invalid@invalid.invalid> Date Tue, 6 Jul 2021 09:00:05 +0200 Newsgroups dbase.getting-started On 2021/07/05 15:51, Milind Nighojkar wrote: > Ashat Yes  am from Pune > > Screen shots are added > If all you want to do is show the status from the rec_status table you don't need to JOIN the rec_status table to the todolist table. You can use the lookupSQL property of the status_id field in the todolist table to do this.  When you display the table in a grid you will see the status instead oof the status_id value. This way the todolist table remains editable.     this.TODOLIST1 = new QUERY(this)     with (this.TODOLIST1)        left = 13.0        top = 2.0        width = 7.0        height = 1.0        sql = 'select * from todolist'        active = true     endwith     with (this.TODOLIST1.rowset)        with (fields["status_id"])           lookupSQL = "select rec_status_id,rec_status from rec_status"        endwith     endwith Mervyn.