# 3 Column Drop Down Menu

**URL:** <https://forum.inductiveautomation.com/t/3-column-drop-down-menu/7482>\
**Category:** Ignition\
**Created:** [October 28, 2013, 8:18pm UTC](https://forum.inductiveautomation.com/t/3-column-drop-down-menu/7482 "2013-10-28T20:18:12Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![disav](https://avatars.discourse-cdn.com/v4/letter/d/8edcca/32.png) [@disav](https://forum.inductiveautomation.com/u/disav)\
**Post date:** [October 28, 2013, 8:18pm UTC](https://forum.inductiveautomation.com/t/3-column-drop-down-menu/7482/1 "2013-10-28T20:18:12Z")

</div>

New to the ignition development environment. Was wondering if it is possible to have a drop down menu that displays 3 columns in a table. Ideally with headers and all displaying integers such as the following.

ID1 ID2 ID3

## ##

I currently have the dropdown binded with the following:  
Select ID1  
From Database  
Where ID2 \>= 0 or ID3 \>=0

ID 2 and 3 would soley be used for reference in selecting from the dropdown.

Thanks!

---

<div class="post-metadata">

**Author:** ![Kyle\_Chase](https://avatars.discourse-cdn.com/v4/letter/k/9de0a6/32.png) [@Kyle\_Chase](https://forum.inductiveautomation.com/u/Kyle_Chase)\
**Post date:** [October 28, 2013, 11:29pm UTC](https://forum.inductiveautomation.com/t/3-column-drop-down-menu/7482/2 "2013-10-28T23:29:50Z")

</div>

Set the dropdown type to table and use the following query

`Select ID1,ID2,ID3
From Database
Where ID2 >= 0 or ID3 >=0`