This is not the real app, but it is very, very close in structure to what I actually want to accomplish. Consider the four tables:
Continent, Country, CivicUnit, Capitol
The primary key of Continent is ConName.
The primary key of Country is ConName, CountryName
The primary key of CivicUnit is UnitName.
I also have available if needed is a table (CCCU) whose primary key is ConName, CountryName, UnitName.
The primary key of Capitol is Continent, Country, CivicUnit, CapitolName.
There are a small number of continents, countries and civic units, so if possible I would like to do most things client side.
The goal of app is to perform CRUD operations on the capitol records. There are a huge number of Capitol records (tens of thousands). There may be other goals, but they would be secondary at this time.
The UI I would like to implement looks like this:
Continent_ComboBox Country_ComboBox CivicUnit_ComboBox
Capitol_DropDownList_or_Grid Capitol_Form
The capitol_dropdownlist_or_grid would list all the capitol names for the given triple (Continent, Country, CivicUnit) and when selected the full record would appear in the form to be edited. Due to the nature of the data, it is unlikely records would be deleted and created rarely. The app could go into production initially with just an edit and save option on the form. The primary key fields would not need editing.
I have tried cascading combo boxes on the datasets for Continent, Country and CCCU, but I couldn't see how to turn that to my advantage.
It seems to me that I should be able to utilize the foreign keys to populate my ComboBoxes, but I can't figure out how to do that either. Even though I have my foreign key annotations in my BE schema, KUIB doesn't seem to either recognize them or let me do something with them.
I'm not wedded to the foreign key idea, but it seem to be what all the annotating is driving toward.
Am I on the wrong track?
Hello Greg,
The foreign key support in Kendo UI Builder can be helpful to handle the first 3 ComboBoxes in the Data Grid Form.
However, for the DropDownList, you would need to filter the data yourself using a filter with the multiple keys.
In this example, you can find a DropDownList with a custom filter:
community.progress.com/.../2923.how-to-add-a-combo-box-or-a-dropdownlist-to-a-grid-in-a-custom-view
Here is an example of cascading DropDownLists, if you are writing a custom view and not using the foreign key support:
oemobiledemo.progress.com/.../cascadingDDL.html
Please let me know if you need more information.
I hope this helps.
In the cascadingDDL.html, your combo boxes have a nice Select title and a nice appearance. Is that some css you'd be willing to share?
The titling especially.