# Drop Down Box with 3 or more columns

**URL:** <https://forum.inductiveautomation.com/t/drop-down-box-with-3-or-more-columns/1366>\
**Category:** Archived Topics\
**Created:** [November 8, 2009, 4:50pm UTC](https://forum.inductiveautomation.com/t/drop-down-box-with-3-or-more-columns/1366 "2009-11-08T16:50:48Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![DB2](https://avatars.discourse-cdn.com/v4/letter/d/e0b2c6/32.png) [@DB2](https://forum.inductiveautomation.com/u/DB2)\
**Post date:** [November 8, 2009, 4:50pm UTC](https://forum.inductiveautomation.com/t/drop-down-box-with-3-or-more-columns/1366/1 "2009-11-08T16:50:48Z")

</div>

I have a drop down box with 3 columns, I need to bind a text field to column number 2, hwo would I go about this?

---

<div class="post-metadata">

**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Post date:** [November 8, 2009, 5:10pm UTC](https://forum.inductiveautomation.com/t/drop-down-box-with-3-or-more-columns/1366/2 "2009-11-08T17:10:37Z")

</div>

You should be able to use the lookup() expression to bind into any column of the dropdown’s dataset using the selected value as the lookup key.

---

<div class="post-metadata">

**Author:** ![juang](https://avatars.discourse-cdn.com/v4/letter/j/9dc877/32.png) [@juang](https://forum.inductiveautomation.com/u/juang)\
**Post date:** [August 8, 2018, 8:33pm UTC](https://forum.inductiveautomation.com/t/drop-down-box-with-3-or-more-columns/1366/3 "2018-08-08T20:33:46Z")

</div>

hello i know this is and old topic. but i need help.

so i have query that select productid(int), sku(string), recid(int).

product id has duplicates. but i need to get the value of the selected row of the dropdown. column recid. i can’t look for the selected index because it is not in the dataset.

Thanks.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [August 8, 2018, 9:23pm UTC](https://forum.inductiveautomation.com/t/drop-down-box-with-3-or-more-columns/1366/4 "2018-08-08T21:23:41Z")

</div>

The modern dropdown box exposes a selectedIndex property that can be used directly as the row number instead of lookup().