Sure.  This is something that we do all of the time.  Probably a good example would be when you choose a country from our website, the provinces automatically load for that region.  We use this logic in our medical application as well.

If you have absolutely no relationship or tie between the two tables, then SF or no SF...it is going to be difficult to know how to populate the combo...so on that point I was a bit confused.  But taking our countries / provinces example, we do not populate the provinces until a country is selected.  So the countries combo populates using the BusinessObject method and the PopulationDataSourceSettings on the FormLoad.  When the SelectedValue (or SelectedIndex) changes on the country, it then calls the cboProvinces.Requery() which uses the country to populate only those provinces that belong to the country.

Hope that helps.

I have 3 or more cascaded objects - for example: Country (CountryID and CountryName columns), Town (TownID, TownName and CountryID columns) and Street (StreetID, StreetName and TownID columns) - just for illustration, I'm not using objects for towns and streets . There is 1:N relationship between Country and Town (through CountryID column) and 1:N relationship between Town and Street (through TownID column).

Now I want to use StrataFrame standard windows form for adding and editing of Street object. It works fine with Street object as a primary object. I can even use combo for selecting town. But I would like to use another combo that would be used for selecting country and based on selected country the combo with towns filtered - however I do not know how to do it since there is no direct relationship between Country and Street objects. Is there any possibility to make it?

Thanks a lot

Jiri Brazda