Subject Re: Appending records From Mervyn Bick <invalid@invalid.invalid> Date Wed, 27 Sep 2023 09:19:47 +0200 Newsgroups dbase.getting-started On 2023/09/26 13:17, Mervyn Bick wrote: ..... > To use OODML instead of XDML to determine the next order number add a > new query to your form. > >     this.order_number = new QUERY(this) >     with (this.order_number) >        left = 20.0 >        width = 7.0 >        height = 1.0 >        database = form.expenses1 >        sql = "select max(biolinc_on) as last_order from expenditures > where biolinc_on like :biolinc" >        params['biolinc_on'] = '%' //Rowset will have multiple records. >        active = true >     endwith Oops. Mind in neutral when I wrote that.  The rowset will have one record with one field.  The contents of the field will be the last order number for the order type last in an alphabetical list, say, ZAB0101. Mervyn.