# BAQ - SO Attn and Email fields

**URL:** <https://www.epiusers.help/t/baq-so-attn-and-email-fields/96050>\
**Category:** Kinetic ERP\
**Tags:** baq\
**Created:** [November 2, 2022, 5:07pm UTC](https://www.epiusers.help/t/baq-so-attn-and-email-fields/96050 "2022-11-02T17:07:52Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![cchang](https://www.epiusers.help/user_avatar/www.epiusers.help/cchang/32/13056_2.png) [@cchang](https://www.epiusers.help/u/cchang)\
**Post date:** [November 2, 2022, 5:07pm UTC](https://www.epiusers.help/t/baq-so-attn-and-email-fields/96050/1 "2022-11-02T17:07:52Z")

</div>

Is it possible to pull in the Sales Order Attn field and Email in the Header Sold To fields in a BAQ? I tried joining the OrderHed to Customer and CustCnt but it’s bringing in all the contacts. I just need to bring in what’s displayed in the SO Header Sold To.

![image](https://www.epiusers.help/uploads/default/original/3X/7/9/79f4ee9590f7689068b0a3fcdb78ec613cc2de43.png)

---

<div class="post-metadata">

**Author:** ![jkane](https://www.epiusers.help/user_avatar/www.epiusers.help/jkane/32/57624_2.png) [@jkane](https://www.epiusers.help/u/jkane)\
**Post date:** [November 2, 2022, 5:13pm UTC](https://www.epiusers.help/t/baq-so-attn-and-email-fields/96050/2 "2022-11-02T17:13:42Z")

</div>

I believe the two fields you want to join to are OrderHed.BTConNum and OrderHed.ShpConNum

---

<div class="post-metadata">

**Author:** ![cchang](https://www.epiusers.help/user_avatar/www.epiusers.help/cchang/32/13056_2.png) [@cchang](https://www.epiusers.help/u/cchang)\
**Post date:** [November 2, 2022, 5:21pm UTC](https://www.epiusers.help/t/baq-so-attn-and-email-fields/96050/3 "2022-11-02T17:21:43Z")

</div>

I tried the OrderHed.BTConNum to the Customer table and then from Customer to CustCnt but it brings in all contact and not specifically the one selected on the Sales Order.

---

<div class="post-metadata">

**Author:** ![jkane](https://www.epiusers.help/user_avatar/www.epiusers.help/jkane/32/57624_2.png) [@jkane](https://www.epiusers.help/u/jkane)\
**Post date:** [November 2, 2022, 5:32pm UTC](https://www.epiusers.help/t/baq-so-attn-and-email-fields/96050/4 "2022-11-02T17:32:32Z")

</div>

You need to connect right to the CustCnt table.

For BT, the join is to CustNum, ConNum, and ShipToNum = null

For ST, the join is CustNum, ConNum, and ShipToNum