>I would like to know how most of you here implement one-many form. I am curious because when I use the most direct way, I encounter a whole chunk of problems which I have not seen others voice out besides myself. I begin to wonder if the way I thought to be most direct is wrong.
>
>I use DE and buffering. My main problem is in the replacement of foreign key in the detail table and the controlling of the detail table grid pointer. I like the traditional way of having a spreadsheet-like details grid where people can just use arrow key and enter key to move around the grid. However, I never seem to get everything right after nearly A YEAR of hardwork using VFP.
>
>Can someone tell me how to replace the foreign key and how to refresh the grid so that everything works well?


Edward Pikman said something about editing in a grid. He said
grids should be used mainly for browsing and viewing only. You
can trigger an edit screen from within the grid. But I would not
try to emulate a spread-sheet like entry. Also check the KB
about setting up one to many relationship. There is also an
example of a one to many grid shipped with VFP 3.0 and ( 5.0
also, I think ).

HTH :)

Dan