For editing with grids, I show a grid on the bottom of a form but right above it I have the corresponding input controls. When the user changes a row in the grid the editing controls are refreshed. So, they don't have to go to another form.

Personally, I'd much rather be able to do edits in the grid. If I was going to be doing a lot (or even much) data entry myself I wouldn't really like this system. But it's a heck of a lot more stable and simple. Which my users need more than heavy data entry.

Now, one caveat...even though my heart lives in a perfect world, my brain and boss do not. So, in my next lifetime I'm sure I'll have a perfect nTier design :-)

These grids were designed in 3.0 (before the new property ALLOWADDNEW), and they use tables. Tables for grids I set to use table buffering (optimistic). In the grid's click event (which fires when a _blank_ line is clicked) does something like this:

IF thisform.falloncmd1.editMode
INSERT INTO wlevel (batchid, sp_id) VALUES (batches.id, batches.period)
ELSE
DODEFAULT()
ENDIF

I dislike how grids refresh and scroll their records, but my users couldn't care less, and so I don't have to fight the same interface problems other developers have.

FWIW, I have one grid that I still do editing _in_. It uses a really complicated container object with, oh, 3 dozen fields or so, including checkboxes, dropdowns, and even grids. It actually works really well. Hmmm. Which makes me think all my grids should just have containers ;-)

HTH helps.

>>2. I've stopped using my grids to EDIT records so there are only textboxes in 'em now. And my life is _much_ improved :-)
>
>After using a grid for the first time, I can certainly believe that! However, my grid is very simple--it just shows a date, an amount and a few checkboxes. I just couldn't see making my users pull up another form just to check one of those boxes.
>
>>3. My parent add button adds only a parent. The grid handles adding a child. Pretty simple actually, just a click on a blank line.
>
>As a grid novice, could I ask how you do that?