>>>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
>
>If you don't use spreadsheet-like detail grid, how do you usually do it?


For data entry, its just better not to use a grid. I personally
like a spreadsheet-like data entry screen, but it doesn't work
well within VFP.