>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.
IF you are using a DBC then you can use an updateable, parameterized view instead of an SQL. Updateable views are really nice. For reliability reasons set your buffer mode to 5-optimistic. Then you can either update one row at a time or multiple rows at a time, depending on how you set the parameters to the TABLEUPDATE command.
Nebraska Dept of Revenue