# Get data from other field in a same page

**URL:** <https://discourse.cakephp.org/t/get-data-from-other-field-in-a-same-page/9828>\
**Category:** Need Help\
**Created:** [October 18, 2021, 3:35am UTC](https://discourse.cakephp.org/t/get-data-from-other-field-in-a-same-page/9828 "2021-10-18T03:35:27Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![werkudara](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.cakephp.org/werkudara/32/1772_2.png) [@werkudara](https://discourse.cakephp.org/u/werkudara)\
**Post date:** [October 18, 2021, 3:35am UTC](https://discourse.cakephp.org/t/get-data-from-other-field-in-a-same-page/9828/1 "2021-10-18T03:35:27Z")

</div>

guys, I need your help  
Is there any references that can help me if I have value in a field selected that can show data where that field selected  
for example, there are 2 table states and cities  
in states, there are data like Japan, Indonesia, China, and other  
but when I choose Japan will only show data Japan’s city in the city field select box  
thank you

---

<div class="post-metadata">

**Author:** ![jimgwhit](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.cakephp.org/jimgwhit/32/378_2.png) [@jimgwhit](https://discourse.cakephp.org/u/jimgwhit)\
**Post date:** [October 19, 2021, 3:58am UTC](https://discourse.cakephp.org/t/get-data-from-other-field-in-a-same-page/9828/2 "2021-10-19T03:58:52Z")

</div>

There are many tutorials on dependent drop downs. A Google search for city state dependent drop down should show many results.

Edit: Normally this is done with ajax.