# Selecting the DB table using drop down list

**URL:** <https://forum.inductiveautomation.com/t/selecting-the-db-table-using-drop-down-list/16824>\
**Category:** General Discussion\
**Created:** [January 31, 2018, 4:54pm UTC](https://forum.inductiveautomation.com/t/selecting-the-db-table-using-drop-down-list/16824 "2018-01-31T16:54:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![shwethag](https://avatars.discourse-cdn.com/v4/letter/s/e47774/32.png) [@shwethag](https://forum.inductiveautomation.com/u/shwethag)\
**Post date:** [January 31, 2018, 4:54pm UTC](https://forum.inductiveautomation.com/t/selecting-the-db-table-using-drop-down-list/16824/1 "2018-01-31T16:54:00Z")

</div>

Hello:  
I’m trying to extract the data from the another database to which another OPC is writing. I am able to access the database and extract the required table to the table I’ve created in ignition. But there are many tables in that database which I would like to read. Is there any way that I can mention those table names in a drop down list so that if I select a table name, it will be automatically populated to the ignition software table? Or, do I need to create individual tables in the ignition software and statically assign the tables ?

Thanks,  
Shwetha.

---

<div class="post-metadata">

**Author:** ![salbrechtsen](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/salbrechtsen/32/18660_2.png) [@salbrechtsen](https://forum.inductiveautomation.com/u/salbrechtsen)\
**Post date:** [January 31, 2018, 5:26pm UTC](https://forum.inductiveautomation.com/t/selecting-the-db-table-using-drop-down-list/16824/2 "2018-01-31T17:26:23Z")

</div>

Is Ignition connected to both databases?

---

<div class="post-metadata">

**Author:** ![shwethag](https://avatars.discourse-cdn.com/v4/letter/s/e47774/32.png) [@shwethag](https://forum.inductiveautomation.com/u/shwethag)\
**Post date:** [January 31, 2018, 5:31pm UTC](https://forum.inductiveautomation.com/t/selecting-the-db-table-using-drop-down-list/16824/3 "2018-01-31T17:31:41Z")

</div>

yes, it is connected

---

<div class="post-metadata">

**Author:** ![salbrechtsen](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/salbrechtsen/32/18660_2.png) [@salbrechtsen](https://forum.inductiveautomation.com/u/salbrechtsen)\
**Post date:** [January 31, 2018, 5:34pm UTC](https://forum.inductiveautomation.com/t/selecting-the-db-table-using-drop-down-list/16824/4 "2018-01-31T17:34:27Z")

</div>

You can set the `data` property of an Ignition table through scripting. Use the system.db functions to query data from your database.

Perhaps create a `propertyChange` script on your dropdown component and use the selected table name on the dropdown component to determine what data to get in your script.