I am trying to filter the results in an EpiCombo that I have placed on the Project Memo. I want to retrieve the Character01 value from table UD20 where the ProjectID (Key1 in the UD20 table) = Key1 in the Memo table (ProjectID). At present, I am getting all the Character01 values and my filter is n…

Well, I tried fiddling with the properties and got the same results as you. Went into the script and got it to work with this: private void epiComboC1_BeforeDropDown(object sender, System.ComponentModel.CancelEventArgs args) { // ** Place Event Handling Code Here ** EpiDataView edv = oTrans.…

Depends on how complex you want to get. Here’s a pretty basic one: [image] Otherwise, give this a go: [image] Dynamically changing a ComboBox EpiFilter based on other fields ERP 10 Here is the link to the video

Hi Aaron, Thanks for this. When I hard code the ProjectID as below, it works. It’s when I use Key1, which is the ProjectID in both the UD20 and the Memo table, it does not work, it just returns all the character01 values in the table. [image]

It’s hard to tell from your original screenshot if your syntax contains a period or a comma (it looks like a period). Try some variations: Key1 = '?[Key1,'']' Key1 = '?[Memo.Key1,'']' Place them in the EpiFIltersAppend and see if that works. You could also try method #2 here. [imag…

I’ve tried just about every combination I can think of now. :frowning: The first customer displays correctly but when I click the dropdown to select from the list, every customer in the table is there, I just want the ones from UD20 where Key1 matches Key1 in the memo table [image]

I’ll see if I can recreate your scenario on Monday; I’ll let you know what I find out.

Thanks for taking the time to help me with this. I will implement your example and let you know how I get on. Thanks again.

Hi Aaron, Do I leave this in there or remove it? [image]

Leave all of the setup for that, but remove any filters you have on that screen.

I must be doing something wrong. I have cleared everything from the filters; [image] Inserted your code in the script editor, but it still returns all the customers from UD20 :thinking: [image]

Looks like you’re only pulling back Chacter01. Either remove that (since you have a DescColumnName and Value Member already set), or add Key1 to the EpiHiddenColumnsAppend.

Filtering an EpiCombo

Epicor ERP 10

hmwillett (Hannah Willett) August 6, 2021, 11:55am 2

Depends on how complex you want to get.
Here’s a pretty basic one:

Otherwise, give this a go:

Topic		Replies	Views
[Customization] Can't find reliable event updating drop down column filter Epicor ERP 10 e10 , customization	25	3616	December 10, 2019
C# Customization - Remove EpiUltraBox Values (Part of Attempt to Create Linked EpiUltraBoxes like in Topic Tree of Case Entry) Epicor ERP 9	8	927	December 12, 2017
V8 Combo Box setup help Vista/Vantage 8 combox-setup	3	823	March 6, 2019
EpiCombo Dynamic Filtering with LIKE Epicor ERP 10 customization	10	5236	December 5, 2024
Filtering DropDown based on the value of another DropDown Epicor ERP 10 customization	3	1860	September 6, 2019

Filtering an EpiCombo

Related topics