In the BAQ Information properties, set your DisplayMember to the {table}.{field} value you want the user to see in the box. Set the DynamicQueryID to your BAQ name. Set the ValueMember to the {table}.{field} value you want the selection to store in your binding.
Launched Developer mode and made the Customization of the Base Layout.
Within the customization I added the EpiCombo Drop Down and pointed it to the UD Column I created.
Restarted Epicor but had no luck. The Drop down is there but its grayed out. Any Suggestions? @Aaron_Moreng I’m gonna go your route if I cant get this one to work.
They should already be joined in the “Vendor” data view. Hence why you can select your RiskRating_c from the drop-down. Do you mean in a BAQ or something?
Dan is right, the view presented to the application is a sql view of erp.vendor and erp.vendor_ud (don’t remember if it’s pre or post fix) so the data is essentially one table to work with.
If you’re using SQL Server Management Studio, there will be a view that automatically combines (joins) the tables for you. If you had to do it manually, you’d use the ForeignSysRowID column in the UD table and join it to the Vendor SysRowID column (I think). I’ve never had to do it though because the system has always done it for me.
LOL. I hear you. I only write queries to pull information so some employees can have custom reports. I then insert them into excel where all they have to do is hit refresh. They are never changing or looking at the code. Also, found the correct join on another thread.
left outer join Erp.table_UD on table.SysRowID = table_UD.ForeignSysRowID
In case anyone was wondering. The reason it did not pull the codes at first was because the codes need to be linked in the properties prior to inserting the UD column into the customization. Otherwise you will have to delete the epicombo, add the codes to it, and re add it to the customization.
@Banderson has a cool Excel workbook that does the same with REST and BAQs. If you’re nice, he might share it with you and you can avoid the direct DB access.
@LexLawnjac, Here is the link to my post with some instructions on how the Excel workbook is setup and there is a demo file attached to the post you can use as a starting point.