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?