Subject Re: GRID From Mustansir Ghor <mustan31@hotmail.com> Date Mon, 13 Mar 2017 15:36:27 -0400 Newsgroups dbase.getting-started Dear Ken sir Thank you. form.grid1.dalalink.first() did work. Yes there is a need to limit records because it needs to print on a  perforated receipt of 3.5" length in a dot matrix printer  which can accommodate only six lines besides other things. Also rather than to empty table, to make fields null seems better option. In order to avoid XDML then next better option will be to make all fields null is by iteration. Wiil that be right Best Regards Mustansir Ken Mayer Wrote: > On 3/13/2017 12:46 AM, Mustansir Ghor wrote: > > Dear Ken Sir > > > > I have a grid which is datalink to a table (it has 6 records and addrow property is set to false) to be used for editing. There are 2 colums in the in the grid. > > > > 1st one is a combobox which is tied up to lookupSQL with another table (this table has item list and price for each item). > > > > 2nd column is an entryfield which takes the price for item selected in the combobox. > > > > Below the grid we have 2 pushbuttons, and an entryfield that calculates total value of items in the grid. > > > > 1st button is Save : With this button the data in the grid  table needs to be transferred to a permanent table. > > > > 2nd button is Cancel: With this button the grid table needs to to be emptied and and grid pointer to be set to row 1. > > > > I am curious why you need specifically six rows? Why not have a button > to add rows as needed? Then you could just use the database.emptyTable() > method to clear out the grid ... > > You could max the number of rows by counting them, so if the user tried > to add a seventh row, they couldn't. Or, is there a need for a limit? > > Ken > > > -- > *Ken Mayer* > Ken's dBASE Page: http://www.goldenstag.net/dbase > The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp > dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm