Subject Re: Property not getting set in Form using query From Milind Nighojkar <milinigh@yahoo.com> Date Wed, 07 Jul 2021 13:40:49 -0400 Newsgroups dbase.getting-started Hi Mervyn, Your suggestion worked Thanks Milind Nighojkar Mervyn Bick Wrote: > 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.