# UD Tables in Epicor BAQs

**URL:** <https://www.epiusers.help/t/ud-tables-in-epicor-baqs/88238>\
**Category:** Epicor ERP 10\
**Tags:** baq\
**Created:** [March 9, 2022, 2:42pm UTC](https://www.epiusers.help/t/ud-tables-in-epicor-baqs/88238 "2022-03-09T14:42:42Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![MTooch](https://www.epiusers.help/letter_avatar_proxy/v4/letter/m/ad7895/32.png) [@MTooch](https://www.epiusers.help/u/MTooch)\
**Post date:** [March 9, 2022, 2:42pm UTC](https://www.epiusers.help/t/ud-tables-in-epicor-baqs/88238/1 "2022-03-09T14:42:42Z")

</div>

Hey All,  
So I’m pretty new to UD tables and was wondering how i can link a UD table to the Part table. The person before me created a UD table with a few values and added that as a dropdown to Part Maintenance. I need to create a BAQ that pulls part numbers based on what dropdown was selected. None of the columns are labeled so its all Key1 Key2 ect. The only values in the UD table are Company and the Custom tags that were entered (It was used to identify parts on an LTA). How can I link(UD01) to the part table so I can make this query?

---

<div class="post-metadata">

**Author:** ![josecgomez](https://www.epiusers.help/user_avatar/www.epiusers.help/josecgomez/32/55731_2.png) [@josecgomez](https://www.epiusers.help/u/josecgomez)\
**Post date:** [March 9, 2022, 2:44pm UTC](https://www.epiusers.help/t/ud-tables-in-epicor-baqs/88238/2 "2022-03-09T14:44:24Z")

</div>

You need to link Company-\> Company and PartNum → KeyXXX where KeyXXX is the PartNumber that is stored in the UD table.

---

<div class="post-metadata">

**Author:** ![MTooch](https://www.epiusers.help/letter_avatar_proxy/v4/letter/m/ad7895/32.png) [@MTooch](https://www.epiusers.help/u/MTooch)\
**Post date:** [March 9, 2022, 3:05pm UTC](https://www.epiusers.help/t/ud-tables-in-epicor-baqs/88238/3 "2022-03-09T15:05:29Z")

</div>

So right now i dont believe the part number is stored in the UD Table. How can i do that?

---

<div class="post-metadata">

**Author:** ![NateS](https://www.epiusers.help/user_avatar/www.epiusers.help/nates/32/18519_2.png) [@NateS](https://www.epiusers.help/u/NateS)\
**Post date:** [March 9, 2022, 5:32pm UTC](https://www.epiusers.help/t/ud-tables-in-epicor-baqs/88238/4 "2022-03-09T17:32:48Z")

</div>

How do you choose the part numbers based on your drop-down criteria?

If you just want to update your UD table, you will need to setup an updatable BAQ. You can do most of the simple updates right from the BAQ designer. But if you need to edit lots of records at once, then you are looking at an advanced BPM. Both methods are doable, it all depends on how you link things up.

---

<div class="post-metadata">

**Author:** ![Vinaykamboj](https://www.epiusers.help/user_avatar/www.epiusers.help/vinaykamboj/32/14848_2.png) [@Vinaykamboj](https://www.epiusers.help/u/Vinaykamboj)\
**Post date:** [March 10, 2022, 2:29pm UTC](https://www.epiusers.help/t/ud-tables-in-epicor-baqs/88238/5 "2022-03-10T14:29:15Z")

</div>

Link the UD table and part based on whatever is the common field between the two, which in your case looks like it is the tags.