# Table with dropdown combobox

**URL:** <https://forum.inductiveautomation.com/t/table-with-dropdown-combobox/4178>\
**Category:** Ignition\
**Created:** [March 20, 2012, 6:50pm UTC](https://forum.inductiveautomation.com/t/table-with-dropdown-combobox/4178 "2012-03-20T18:50:05Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Greg.Buehler](https://avatars.discourse-cdn.com/v4/letter/g/ecc23a/32.png) [@Greg.Buehler](https://forum.inductiveautomation.com/u/Greg.Buehler)\
**Post date:** [March 20, 2012, 7:45pm UTC](https://forum.inductiveautomation.com/t/table-with-dropdown-combobox/4178/2 "2012-03-20T19:45:41Z")

</div>

So you have a table containing downtime information indexed by EquipmentId, and you want to filter the contents of this table using a combobox populated with equipment?

Combobox Databinding:

```auto
SELECT EquipmentId, EquipmentName FROM tbl_Downtime;
```

Table Databinding:

```auto
SELECT * FROM tbl_Downtime WHERE EquipmentId={SomePath.ToThe.Combobox.selectedValue};
```

---

_[View the full topic](https://forum.inductiveautomation.com/t/table-with-dropdown-combobox/4178)._