I have following data in a lookup table.
I have an editable UltraGrid that allows users to select a category for each row, using a column having UltraComboEditor to display categories.
Users can only select categories that are not deleted i.e. Electronics and Smartphones. However, if the row already has a record that references deleted category (Personal care, Id=2), it should be added to the list of items in the UltraComboEditor
For all new rows, it UltraComboEditor should only contain non-deleted categories.
My Category column is similar to EmployeeID column in the following snapshot:
How can I accomplish that?
When I tried to post my question, the progress indicator stayed forever and did not notify me that question was posted successfully. I am sorry about that.