State & City Management
States
| Id | State Name | Remove |
|---|
Add State
Cities
| Id | City Name | State Name | Is Capital | Info | Remove |
|---|
Add City
Find City Details
Business requirement — Database Operation 9
Filter the city listing immediately when a state is selected.
- Load all states into a dropdown.
- Include an All States option.
- Refresh the city query on dropdown change.
- Return only cities belonging to the selected StateId.