Hiya Erik....
>>Thanks for the input. I like your second method. The problem I have is that the Order Header table has 82 fields (most of which are Logical). A grid would probably be to cumbersome for data entry. A multi-page form would probably work best for the Order Header table with a grid for the order line-item table.
>
>I almost never handle data entry in a grid, unless a client insists. I use grids for picklists and quick reference. Toe edit, highlight a row and click to open up an edit form, or doubleclick a record to do the same.
>
>
Amen, brother. One of the problems there is application consistancy. If you allow direct grid edit on a grid, then the user (rightfully) expects it on all grids in the application. In my experience, some grids list some complex data that requires an edit form to reasonably populate all fields.
Consistancy is a buzz-word with me. What's the point of OOP with an inconsistant interface?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05