Steven,
I prefer Jerry's method of using parameterized views, but you can also take a cursor and make it updateable. First you USE it with the AGAIN clause to make it read/write instead of read only. Then you use CursorSetProp to set the necessary parameters.

SELECT * from Mytable WHERE...  INTO MyCursor

USE dbf('MyCursor') AGAIN in 0 alias FinalCursor

CursorSetProp("Buffering", 5, "FinalCursor")
CursorSetProp("SendUpdates", .T., "FinalCursor")

as well as other CursorSetProp() calls to show the key fields, updateable fields, etc. See the Help on CursorSetProp() for a complete list.

It's a LOT easier, though, to use a parameterized view.

Barbara


>I have a table with task deffinitions. This includes department identifiers. I have a second table which lists customers and all the tasks which are associated wiyh that customer. In a grid I need to be able to view the particular customer and their tasks in department order and also be able to edit and update the data. I can get the resultant grid I need with SQL but then I can't update. Please help.