I have a question about the best way to retrieve and query records in memory. Below is the sample of the data. Basically what I want to do is:
If a user picks a repcode from a dropdown is pick all the condcodes associated and populate a different combobox. Then when the user picks a condcode from the next dropdown dropdown populate another combobox with the associated simcodes.
Normally I would just run a series of queries to get the next set of rows. But this form will be used with a high frequency and I am trying to minimize the DB calls.
I am open to any ideas on this, collections, datatables, etc.
Thanks for your help and attention.