# Inactive 'Prompt' checkbox in Updatable Dashboard

**URL:** <https://www.epiusers.help/t/inactive-prompt-checkbox-in-updatable-dashboard/81864>\
**Category:** Epicor ERP 10\
**Tags:** dashboard\
**Created:** [August 23, 2021, 2:59pm UTC](https://www.epiusers.help/t/inactive-prompt-checkbox-in-updatable-dashboard/81864 "2021-08-23T14:59:43Z")\
**Posts on this page:** 1\
**Showing post:** 11

<div class="post-metadata">

**Author:** ![DaShMa](https://www.epiusers.help/user_avatar/www.epiusers.help/dashma/32/65730_2.png) [@DaShMa](https://www.epiusers.help/u/DaShMa)\
**Post date:** [September 2, 2021, 12:30am UTC](https://www.epiusers.help/t/inactive-prompt-checkbox-in-updatable-dashboard/81864/11 "2021-09-02T00:30:32Z")

</div>

After some more playing around, and keyword searches, I landed on this prior post where you chimed in. This is what I’m experiencing: the field I want to update is in Subquery 2, with Left Join.

> [@Price List Update with UBAQ](https://www.epiusers.help/t/price-list-update-with-ubaq/74344):
>
> We have 6 customer price lists. We would like to be able to see all the prices for one part on one grid. I made a BAQ that looks like this: So far so good. I used a separate subquery for each price list column. (Linked the same PriceLstParts five more times, each with a different price ListCode as the criteria). Now, we would like to make this grid Updateable. I can get the price from the primary query to update, but not the subqueries. Is there some fundamental limitation on UBAQ t…

Oddly, within the uBAQ I can update the field. However, the Dashboard will not allow me to select the field as a Prompt. For further testing, I chose a field from Subquery 1 to be updatable, went back into the dashboard, and voila! I was able to select that top-level field as a Prompt.

At this moment, I definitely feel comfortable thinking it’s because of the subquery. I’m a newb with advanced coding so I’m not real sure how this is going to play out.

---

_[View the full topic](https://www.epiusers.help/t/inactive-prompt-checkbox-in-updatable-dashboard/81864)._
