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 15
Build a dependent-dropdown screen that displays the selected city’s complete details.
- Load every state into the State dropdown on page load.
- Keep City blank until a state is selected.
- Load only cities for the selected state.
- Automatically select that state’s capital when available.
- On Show Details, display all attributes below the form.