basing a data block on a view to be "updated"
I'm new to forms and i'm trying to create a form that displays fields from a complex database view in tabular format (10 records at a time) with the ability to update two of the columns, and save these updates back to a table.
I made the fields on the canvas (layout) for the data block "update-able", but when I open the form, these fields are still grayed out and can't be edited. I'm assuming this is b/c it is based on a view, which can't be updated directly? What is the best way to go about something of this nature? Create two "dummy" columns which are updateable and set them to the value of the two "view" fields?