Subject Re: Property not getting set in Form using query From Mervyn Bick <invalid@invalid.invalid> Date Tue, 6 Jul 2021 09:18:25 +0200 Newsgroups dbase.getting-started On 2021/07/06 09:00, Mervyn Bick wrote: > 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. The todolist table can be edited but if you want to change the rec_status field you can only change it to a value already in the re_status table. Mervyn.