All,

I am developing a Windows form for a table that has a foreign key reference to another table that has thousands of rows. I want to be able to limit the loading of the windows control (combobox, maybe something else) that holds these values for the two times it is needed. I am using the MM.NET business maintenance form with a List page that houses a datagrid and a Properties page that has text boxes and comboboxes for the values of the main table.

First when I navigate to a record on the grid and then click on the Properties tab, since I have not pre-loaded all the values from the foreign key reference I will need to get the value directly from the foreign key value in the selected record and then load the descriptive value from the foreign key table. Second, if I want to edit this value, I want to be able to use some kind of editing feature to query the database for the entered value so I do not have

Any suggestions on a good way to handle this using MM.NET controls?

TIA

Bob