General information
Category:
The Mere Mortals .NET Framework
Title:
Load on demand for foreign key values
Environment versions
Network:
Windows 2003 Server
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
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only