# Update the values in sales table from custtable  for each and every customer.

**URL:** <https://www.dynamicsuser.net/t/update-the-values-in-sales-table-from-custtable-for-each-and-every-customer/61976>\
**Category:** Developer Forum\
**Created:** [November 14, 2016, 9:15am UTC](https://www.dynamicsuser.net/t/update-the-values-in-sales-table-from-custtable-for-each-and-every-customer/61976 "2016-11-14T09:15:08Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sanshe46](https://avatars.discourse-cdn.com/v4/letter/s/8dc957/32.png) [@Sanshe46](https://www.dynamicsuser.net/u/Sanshe46)\
**Post date:** [November 14, 2016, 9:15am UTC](https://www.dynamicsuser.net/t/update-the-values-in-sales-table-from-custtable-for-each-and-every-customer/61976/1 "2016-11-14T09:15:08Z")

</div>

Initially added enum Field called status in both custtable and salestable.My question is while creating a new sales order, a customer account is selected and when selected ,status for that customer should be displayed .I used display method in salestable to display the customer status for particular customer in salescreateorder form and I dont know how to update that displayed status in salestable.

---

<div class="post-metadata">

**Author:** ![Pr0fesional](https://avatars.discourse-cdn.com/v4/letter/p/977dab/32.png) [@Pr0fesional](https://www.dynamicsuser.net/u/Pr0fesional)\
**Post date:** [November 14, 2016, 9:19am UTC](https://www.dynamicsuser.net/t/update-the-values-in-sales-table-from-custtable-for-each-and-every-customer/61976/2 "2016-11-14T09:19:48Z")

</div>

If you are using a display methos on salestable you can’t modified this field, if you wantto update you have to do on customer form.

---

<div class="post-metadata">

**Author:** ![Sanshe46](https://avatars.discourse-cdn.com/v4/letter/s/8dc957/32.png) [@Sanshe46](https://www.dynamicsuser.net/u/Sanshe46)\
**Post date:** [December 1, 2016, 6:35am UTC](https://www.dynamicsuser.net/t/update-the-values-in-sales-table-from-custtable-for-each-and-every-customer/61976/3 "2016-12-01T06:35:16Z")

</div>

Thank You XBB .  
I will see to it.

---

<div class="post-metadata">

**Author:** ![SarathKumar](https://avatars.discourse-cdn.com/v4/letter/s/bbe5ce/32.png) [@SarathKumar](https://www.dynamicsuser.net/u/SarathKumar)\
**Post date:** [December 1, 2016, 6:52am UTC](https://www.dynamicsuser.net/t/update-the-values-in-sales-table-from-custtable-for-each-and-every-customer/61976/4 "2016-12-01T06:52:52Z")

</div>

Hi sanshe46 ,  
There is a method called init fromcusttable in salestable.That may useful to you…

---

<div class="post-metadata">

**Author:** ![Sanshe46](https://avatars.discourse-cdn.com/v4/letter/s/8dc957/32.png) [@Sanshe46](https://www.dynamicsuser.net/u/Sanshe46)\
**Post date:** [December 1, 2016, 7:02am UTC](https://www.dynamicsuser.net/t/update-the-values-in-sales-table-from-custtable-for-each-and-every-customer/61976/5 "2016-12-01T07:02:26Z")

</div>

Yeah Exactly.This method helped me to get the answer .