# Dynamically control available list lookup values based on Table Lookup

**URL:** <https://community.nextw.com/t/dynamically-control-available-list-lookup-values-based-on-table-lookup/1972>\
**Category:** Nextworld Platform\
**Created:** [April 20, 2026, 4:37pm UTC](https://community.nextw.com/t/dynamically-control-available-list-lookup-values-based-on-table-lookup/1972 "2026-04-20T16:37:00Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![brendan.b](https://sea1.discourse-cdn.com/flex001/user_avatar/community.nextw.com/brendan.b/32/269_2.png) [@brendan.b](https://community.nextw.com/u/brendan.b)\
**Post date:** [April 20, 2026, 4:37pm UTC](https://community.nextw.com/t/dynamically-control-available-list-lookup-values-based-on-table-lookup/1972/1 "2026-04-20T16:37:00Z")

</div>

Hello!

I have an app with 2 fields: List Lookup `AvailableColors` and Table Lookup `ColorSupplier`. `AvailableColors` lists all colors in the spectrum (`RED`-`PURPLE`), but some Color Suppliers specify that they only support a subset of colors (e.g. `BLUE`, `YELLOW`, `GREEN`). I want my users to select one available color, but only if it’s one provided by the chosen `ColorSupplier`.

I believe I can validate this via logic block to guarantee that they’ve only selected an acceptable color. But is there a way to limit the options on-screen? I looked into [Dependent Lookups](https://community.nextw.com/t/conditionally-display-list-lookup-values/287/2) but it looks like those are only for List Lookup A controlling List Lookup B, which doesn’t fulfil my need.

---

<div class="post-metadata">

**Author:** ![kerri.h](https://sea1.discourse-cdn.com/flex001/user_avatar/community.nextw.com/kerri.h/32/241_2.png) [@kerri.h](https://community.nextw.com/u/kerri.h)\
**Post date:** [April 20, 2026, 5:00pm UTC](https://community.nextw.com/t/dynamically-control-available-list-lookup-values-based-on-table-lookup/1972/2 "2026-04-20T17:00:12Z")

</div>

If you want to limit what List Lookup values are available to select in the UI you can use Filtered List Lookups in the application definition.

 ![Screenshot 2026-04-20 at 10.59.35 AM](https://us1.discourse-cdn.com/flex001/uploads/nextworld/original/2X/6/6023d16bfc02cf8b6098a57304394dcb46b9f91f.png)

---

<div class="post-metadata">

**Author:** ![brendan.b](https://sea1.discourse-cdn.com/flex001/user_avatar/community.nextw.com/brendan.b/32/269_2.png) [@brendan.b](https://community.nextw.com/u/brendan.b)\
**Post date:** [April 20, 2026, 6:19pm UTC](https://community.nextw.com/t/dynamically-control-available-list-lookup-values-based-on-table-lookup/1972/3 "2026-04-20T18:19:11Z")

</div>

Thanks @kerri.h ! Can those be dynamic at all?

---

<div class="post-metadata">

**Author:** ![kerri.h](https://sea1.discourse-cdn.com/flex001/user_avatar/community.nextw.com/kerri.h/32/241_2.png) [@kerri.h](https://community.nextw.com/u/kerri.h)\
**Post date:** [April 20, 2026, 6:47pm UTC](https://community.nextw.com/t/dynamically-control-available-list-lookup-values-based-on-table-lookup/1972/4 "2026-04-20T18:47:25Z")

</div>

Not to my knowledge, currently static per application. I wouldn’t surprised if there is an existing idea out there for that and if there isn’t we should get one entered.

---

<div class="post-metadata">

**Author:** ![ian.p](https://sea1.discourse-cdn.com/flex001/user_avatar/community.nextw.com/ian.p/32/427_2.png) [@ian.p](https://community.nextw.com/u/ian.p)\
**Post date:** [April 20, 2026, 6:57pm UTC](https://community.nextw.com/t/dynamically-control-available-list-lookup-values-based-on-table-lookup/1972/5 "2026-04-20T18:57:07Z")

</div>

I don’t think there’s a great built-in way to seamlessly do this. Assuming this is a UI use case I would try something like the following:

- user selects a supplier
- on Field Value Change of supplier, the supplier record is fetched and then in logic, loop the subtable or multi-select list lookup which defines which colors are allowable for that supplier
- display the available selections in a work-subtable (can even be a pop-up mini app that is queued as an app link), where each row with a color in it has an action button on it or selection box allowing the user to select one of the rows, that then gets persisted into the selection field

---

<div class="post-metadata">

**Author:** ![brendan.b](https://sea1.discourse-cdn.com/flex001/user_avatar/community.nextw.com/brendan.b/32/269_2.png) [@brendan.b](https://community.nextw.com/u/brendan.b)\
**Post date:** [April 20, 2026, 8:56pm UTC](https://community.nextw.com/t/dynamically-control-available-list-lookup-values-based-on-table-lookup/1972/6 "2026-04-20T20:56:45Z")

</div>

The help page **Control available list lookup values** addresses this and clearly states that it is not possible as I’m imagining today. I’ll try Ian’s approach or see if I can get creative with Dynamic List Lookups and mapping in values from the table lookup.
