Hi, to do that I think the best is to create a temporary table with the results of the query and then display data in the dbgrid. To update the table, you must set the property allowupdate to true. If you want one field to be modified, just lock the others like this:
DbGrid.Columns(1).Locked = True
The problem is thet before the update (in the temporal table), you´ll have to update the real tables.
Claudia