Cascading Combo Against a Field That Does Not Appear in Table Behind Form

[GSevensM]

Hi All,




I'm trying to put together a form to an AzureSQL database (not mine) and am struggling on some location combos.


The table design is that only one parent appears on the relevant table. For example, the Country table has idContinent on it. The City table has idCountry but does not have idContinent.


I'm creating a City form where Cities can be added, and I am struggling to create the cascade because idContinent doesn't appear on the City table. Does anyone know how to create a cascading combo in this circumstance?


Cheers!

[Gicu]

I take it you want to first select a continent then a country then a city. The Continent combo doesn't need to be bound, you simply select a Continent(ID) then in the Country combo row source use Select CountryID,Country FROM Countries WHERE idContinent= Forms!YourForm!cboContinentCombo;

Cheers,

[CJ_London]

is your form a single form or a continuous form? If the latter, then an unbound control for continent won't work because although you see multiple rows, there is actually only one instance of the unbound control. The usual workaround is to put the unbound control(s) in the form header or footer. But once a city is chosen, if you wanted to change it, you would have to go back to continent and start again.

[Bullschmidt]

Cascading Combo Against a Field That Does Not Appear in Table Behind Form

And yes a combobox's RowSource property (which determines the choices shown in the combobox) can be completely different than the combobox's ControlSource (which would generally be a field that the form is based on).