>If you can help I'll be grateful.
John,
I can appreciate your frustration, however the problems your are encountereing are not weaknesses of VFP but rather incomplete understanding of how things work.
If you choose to use a view for your data entry grid, then make that view updatable and make all editing occur in the view. When the user is finished then issue a tableupdate() for that view and the changes will be written back to the original tables.
You can certainly get more than one table's data displayed in a grid, simply set the column's controlsource to
.FieldName for all of the fields you want in the grid.
Using CreateObjet() to add a grid to a fomr is probably not the best way, using the Form's AddObject() method would serve much better, but you still ahve to configure the grid after you've added it by setting its and its column's properties to display things the way you want them displayed
Grids are complex objects with contained columns which in turn contain controls, to get a grid to function to your specs these columns and controls also must be configured.
In fact any one of the methods you described in your message will work fine, IF it is implemented correctly and completely.
