I am trying to create 2 separate combo boxes on the Vendor/Supplier screen that are populated from 2 different User Codes. I created the 2 User Codes and I have UD columns created and mapped correctly. The issue I am running into is when I try to set the combo box Type to UserCodes.UserCodesCombo and set sub type to default, it autopopulates everything and when I try setting the filter param to {CodeTypeParam}=VendSelect (the other is {CodeTypeParam}=EXRResult) it actually combines both User Codes into both combo boxes. I also went into Extended Properties and set the UD Code Type to the correct User Codes.
I didn’t even know you COULD assign UD Codes to columns in Extended Properties. Learn something new everyday!
But, just FYI… not sure if that’s required, because, like I said, I’ve never done it… didn’t even know you COULD do it!
Second…
You don’t HAVE to use “default” here. You can leave it blank and fill in the properties you need. So, take screen shots of the “default” settings… but then go back and remove “default” and fill them back in the way you want/need them.
Below is one of my “custom” UDCode Combos… For example, the “Retrieve Columns” defaults to CodeDesc. But what if you want different, or more columns returned. Well, you have to NOT use the “default” and build the combo settings manually. Then I can set my “Retrieve Columns” to CodeID,CodeDesc (and get both of them pulled back).
Thanks for the in-depth response.
I did do the first response, where I unselected default and filled it in manually and I set the Filters fields to CodeTypeID=‘VendSelect’ and that worked. I did remove the curly braces on the Filters Param and that ALSO worked, with the default settings. My company had used a consultant prior to me working here and I assumed his combo box was correct (it wasn’t, first mistake on my part lol)
Thanks so much! I am also not sure what mapping the User Code to the Extended Properties does, but I saw someone mention it on here before creating this article and was just shooting in the dark
Just an update:
You can leave the Filters field the way the default loads it, but then in the Filters Params field, you will need to put CodeTypeParam=CodeTypeID (replace CodeTypeID with the name of your User Code)
Learn something new everyday!
