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!
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!