Dropdown view in table problematic behaviour - perspective

[Francesco_Vittadini]

Hello
i have a problem on a table with some columns with view

All columns are populated from named query
When a value in columns BC1 to BC4 is choosen using dropdown, that value is immediately written in db (script).
Yellow button will execute some event, remove the line and refresh the table values (refreshbinding).
The problem is that, supposing I've choosen value 1 in dropdown BC1 and value 2 in dropdown BC2 for example, when the line is validated so it will disappear, values 1 and 2 will appear on the line below.
These values will not be written in DB. It's just a matter of visualization which confuses a lot the final user
Moreover if user has to choose value 1 on BC1 he needs to change to 2 for example and then back to 1. Only in this way value 1 will be written in DB
The only way to go back to initial situation is to close the page and reopen it.

I don't know if I was able to explain the issue. I hope so
Anyone has any idea how to bypass this?
Thanks

[nminchin]

@Francesco_Vittadini

when the line is validated so it will disappear, values 1 and 2 will appear on the line below.

I'm not sure what you mean by "validated" here? How come the next row's columns display as the newly selected values?

@Francesco_Vittadini

Moreover if user has to choose value 1 on BC1 he needs to change to 2 for example and then back to 1. Only in this way value 1 will be written in DB

Where is your script defined that writes the selected value into the dB?

If you could get a screen video capture that might help