I'm creating a user interface with a bunch of check boxes, text boxes, and combo boxes.
Rather than hardcode the defaults and pick lists, I'm drawing them from a SQL/Server table that has a record for each text box and combo box pick list value, along with the sort order, ie:
Field: cmbPlex
Sort_Order: 1
Lookup: Simplex
Field: cmbPlex
Sort_Order: 2
Lookup: Duplex
And so on.
In the start off the program, it runs through a predetermined hash list of field name->object pairs, and then does a query to the database to see if there is anything there.
I'd LIKE to simply query a distinct list of "Field" to get a list of things I should be working against, but I don't know how to go from the text sting to the associated object without pre-filling the hash - which I'm trying to avoid.
Can I do the reverse, ie: walk the list of objects, and then match them up against the SQL data? If so, can you point me in a direction?