I have an edit page with a few (to many) drop downs.

First is Opening, the Select Distinct from the data brings back 8 items and I add the other 2 making a total of 10 items.

When the user picks a new item to edit how do I sync the opening "Left" dropdown with the dataset ap_opening column?

TIA

__Stephen