# Custom Field Look

**URL:** <https://www.epiusers.help/t/custom-field-look/50073>\
**Category:** Epicor ERP 10\
**Tags:** e10\
**Created:** [November 27, 2018, 5:27pm UTC](https://www.epiusers.help/t/custom-field-look/50073 "2018-11-27T17:27:13Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Will79](https://www.epiusers.help/letter_avatar_proxy/v4/letter/w/ea666f/32.png) [@Will79](https://www.epiusers.help/u/Will79)\
**Post date:** [November 27, 2018, 5:27pm UTC](https://www.epiusers.help/t/custom-field-look/50073/1 "2018-11-27T17:27:13Z")

</div>

I have a custom filed on OrderHed and I was wondering how to look and see what populates that field? This was created by my predecessor and I have not noticed it till now.

---

<div class="post-metadata">

**Author:** ![tkoch](https://www.epiusers.help/letter_avatar_proxy/v4/letter/t/439d5e/32.png) [@tkoch](https://www.epiusers.help/u/tkoch)\
**Post date:** [November 27, 2018, 6:46pm UTC](https://www.epiusers.help/t/custom-field-look/50073/2 "2018-11-27T18:46:04Z")

</div>

Use Field Help under the Help menu on Order Entry

---

<div class="post-metadata">

**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\
**Post date:** [November 27, 2018, 7:25pm UTC](https://www.epiusers.help/t/custom-field-look/50073/3 "2018-11-27T19:25:22Z")

</div>

Open the customization in developer mode, select the field, and look at the field it is bound to.

If you don’t know how to do the above then you shouldn’t even try - as you could easily mess things up.

Example, here’s our Order Entry Screen with a field added to it.  
 ![image](https://epiusers.help/uploads/default/original/2X/a/a60c47aff705f8e1376513e9c7450c2b851c5693.png)

After selecting the field, the properties show it is bound to  
 ![image](https://epiusers.help/uploads/default/original/2X/e/e564d839db818f05146266b345c0b18e82b5e2cb.png)

---

<div class="post-metadata">

**Author:** ![Will79](https://www.epiusers.help/letter_avatar_proxy/v4/letter/w/ea666f/32.png) [@Will79](https://www.epiusers.help/u/Will79)\
**Post date:** [November 27, 2018, 7:46pm UTC](https://www.epiusers.help/t/custom-field-look/50073/4 "2018-11-27T19:46:46Z")

</div>

Yeah, I saw that area. My question is, in your example, JobNum\_C, what populates that? I am asking because our is CSR\_C and is a drop down box. But the drop down doesn’t have everyone’s name and has duplicates of several others. SO I am trying to find where it is at so can clean it up and get the others added to it.

---

<div class="post-metadata">

**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\
**Post date:** [November 27, 2018, 7:55pm UTC](https://www.epiusers.help/t/custom-field-look/50073/5 "2018-11-27T19:55:51Z")

</div>

Okay … We have a few dropdowns on that form, and there are several ways to populate it.

We have one that is limited to selecting X, P, M, or S. Since that won’t change or doesn’t need to depend on other tables, it is done as a Static List  
 ![image](https://epiusers.help/uploads/default/original/2X/9/9018695cdffba418109a45404e60ec225f33fbfd.png)  
clicking on the button there yields the list editor  
 ![image](https://epiusers.help/uploads/default/original/2X/b/b2e951dd78eb51fcf1def3448442b38c75df8bc1.png)

Two other ones need to be populated from records in a UD table. So I did those with the following code:

```auto
private void setRegionCombo(){
		bool recSelected;
		string whereClause = "Checkbox01 = False";
		
		System.Data.DataSet dsSetRegionCombo = SearchFunctions.listLookup(oTrans,"UD06Adapter",out recSelected, false, whereClause);
		if(recSelected){
			scbRegion.ValueMember = "Key2";
			scbRegion.DataSource = dsSetRegionCombo;
            scbRegion.DisplayMember = "Key2";
            string[] fields = new string[] {"Key2"};
            scbRegion.SetColumnFilter(fields);
			scbRegion.DropDownStyle = UltraComboStyle.DropDownList;
            //scbRegion.LimitToList = true;
			}
		}

```

**NOTE:** This is not the best way to do this. But it worked for me, so I left it.

Try looking at the values in the different properties of the dropdown.

---

<div class="post-metadata">

**Author:** ![Will79](https://www.epiusers.help/letter_avatar_proxy/v4/letter/w/ea666f/32.png) [@Will79](https://www.epiusers.help/u/Will79)\
**Post date:** [November 27, 2018, 7:58pm UTC](https://www.epiusers.help/t/custom-field-look/50073/6 "2018-11-27T19:58:21Z")

</div>

Lastly, how do you create a custom filed on the table?

---

<div class="post-metadata">

**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\
**Post date:** [November 27, 2018, 8:06pm UTC](https://www.epiusers.help/t/custom-field-look/50073/7 "2018-11-27T20:06:56Z")

</div>

The Online Help in E10 does a decent job explaining it.

the following entries describe it in good detail

 ![image](https://epiusers.help/uploads/default/original/2X/c/c2644a84687e73ef7515170930288cb8d517057a.png)

---

<div class="post-metadata">

**Author:** ![Hogardy](https://www.epiusers.help/user_avatar/www.epiusers.help/hogardy/32/18785_2.png) [@Hogardy](https://www.epiusers.help/u/Hogardy)\
**Post date:** [November 28, 2018, 1:08pm UTC](https://www.epiusers.help/t/custom-field-look/50073/8 "2018-11-28T13:08:07Z")

</div>

If it works why break it…

I like your way… as I always use BAQCombo… and found it a bit slow to show the resulting list to popup… I will try your way and see if there is a difference…

Pierre
