In my form there is an LOV for one of the column displayed in form. User can see 3 columns in the LOV, while form has only 1 of those 3 columns displayed
Now user selects a value from LOV and that value is selected ( or rather displayed ) in the form.
How do I make sure all the 3 values are copied back in to the data base table(datablock is based on this table).
I am writing the code in When button pressed trigger of Save button in the form.
While creating LOV you can assign all the fields you want to capture in return value(You can find this using lov wizard>column display tab) so that when user selects a value all the return value fields will get the related data.
Now you can save as normal, all the values will be saved in the database. If your block is based on this table you don't have to write extra code to save, forms save button will do the work for you.