I have a custom grid setup for open purchase order lines, and we've hired someone to maintain up-to-date status on all items that we have on order. The grid displays the standard stuff... item #, purchase order #, qty ordered, qty received, et al. I have added a new field in the PurchaseOrderLine table called ItemStatusNotes, and have added this column to the grid.
What I would like to do is to click on the field in the grid, and when clicked, convert the field to editable text input, which, upon losing focus, will update the corresponding value for the row in question with the updated item status notes. If the data entry cannot be saved on losing focus, alternatively, an "UPDATE FIELD" link at the end of the grid row would be my second choice for saving the data.
Alternatively, if this is not possible, what I would like to do is add a text input box below the grid with a SAVE button next to it. Then, to update an item's status the user would check the box on the far left, enter the updated item status in the text input box below, click save, then update the ItemStatusNotes field with the text from the input box for all items that have been checked, and to refresh the grid so that the updated field value populates in the grid.
I've been screwing around with the settings for the last hour, and cannot for the life of me figure out how either of these things can be done. How can this be accomplished?