I am hoping that this is not nearly as complicated as it seems. All I need is to use the value from one combo box as the parameter on a BAQ that is used as the datasource for another combo box. I have done this in configurator app studio and it is very simple, regular app studio does not have the same options on combo boxes. How can I do this?
@hmwillett Are you aware of any way to do this? ^
Yeah, it’s a pain in the ass.
You need to use dataviews as the source for the combo and filter the views using changed events on the other combo.
Would a parent child relationship on a BAQ dataview work? I am working on the Part menu, so my parent dataview would be Part, my parent column would be the ProdCode product class field, and then the child would be a UD column I have that contains product class within UD02. My end goal being that I want to filter rows from my UD02 table that have the product group/class they have selected within Part.
Admittedly I have used Parent Child relationships on a dataview maybe once since I started with Epicor so I’m not sure this is even what that feature is for.
You can ignore this comment, I figured something else out. Basically ended up using a BAQ data view with a static filter linked to my product class part field. Then put an erp-baq event on the create event to populate my BAQ data view (also found out this isn’t done for you automatically!). So far I think this is the worst offender of shit that should take 20 seconds that ended up taking most of a day to research and execute.
