I’m back with an update. I scrapped the whole thing. After completing the user interface, I started to work on how it would be maintained. Found out that it could not be maintained, so I went back to the drawing board.
The two biggest changes are:
- Instead of storing the data in a UD table, I moved it all to User Codes.
- Instead of trying to drive the selections, I made all of the possible fields available.
This is what the slider looks like now.
As you can see, every possible field has it’s own drop down now. I believe I have around 39 combo boxes on the page now. All but 5 of the fields has it’s own User Code behind it.
Here is a screen shot of the User Codes.
Here is a screen shot of the list of values behind the Class code.
I added 4 fields to the UserCode table to store a couple of check boxes that I am using for filtering, a column used for sorting the values in the drop down, and a field for the value to be used in the part description (I had not noticed the Full Description column until after I added my own. 
)
The original method was very restrictive, if I did not have a group defined for something, the user would never be able to select a value. Now, it is much more reliant on the user to select the correct things. There is nothing stopping them from selecting a value in every field, which is not correct. But I can give access to User Codes to a few people so that when they come across a value that is missing, they can add it them selves. Also, it will be much easier to add a new drop down if needed.
The rest of it functions pretty much the same, but if anyone has any questions, let me know and I can dig in deeper.