APEX

Hello,

I'm having problem with a select list LOV query.

I enter the page and my select list displays an "Extra Value" plus all the other values that I can possibly change the item to, except the value that it is already assigned in the database (so the "Extra Value" does not show up twice in the list).

I change the value in the select list to a different value.

I click "Apply Changes", but I have a validation error somewhere else on my page...so my changes have not yet been saved to the database, but my page has been submitted.

Now if I want to revert the change I made in the select list back to the original value, but I can't, because the LOV query is returning all the values that I can possibly change the item to, except the value that it is saved in the database.

How do I get around this?

Thank you,
Laura