How do you load data into a Combo Box from UD Table?

Kinetic ERP
1

I’m sick of banging my head against a wall. Real simple request.

How do I load data into a Combo Box? I already have the DataView with the data, just need to get it to appear in the field. Is that an event that I need to create?

2

I have tried defining it in the Combo Box Advanced Properties to no success.

image

3

Here are my notes on the three types of combo boxes. Is this what you’re looking for?

Combo Box

To create a simple dropdown list, use a Combo Box. For more info, see Kinetic Control Compendium - #8 by hmwillett.

Reusable (system list): set the following under Properties:

  1. Data > EpBinding = View.Column e.g. SearchFilters.ColumnName
  2. Reusable Combo > Type = ResourceGroup.ResourceGroupCombo (e.g.)
  3. Reusable Combo > Sub Type = default
  4. Advanced > Header = checked

Hardcoded list : set the following under Properties:

  1. Data > EpBinding = View.Column e.g. SearchFilters.ProjectStatus
  2. Advanced > Drop Down Style = DropDownList
  3. Advanced > Append List = checked
  4. Advanced > TextField = display
  5. Advanced > Value Field = value
  6. Add the list items under Advanced > List

BAQ list : set the following under Properties:

  1. Data > EpBinding = View.Column e.g. SearchFilters.ProjectStatus
  2. Advanced > Data Mode = rows
  3. Advanced > BAQ Query = id of the BAQ with the results, e.g. IA_PartClassesnoX
  4. Advanced > TextField = what shows up in the list, e.g. PartClass_Description
  5. Advanced > Value Field = the key field, e.g. PartClass_ClassID

Hardcoded List example:
image

image
image357×604 18.3 KB

image
image779×268 26.3 KB

2 Likes
4

Unfortunately, no. But I am definitely stealing your notes. :smiling_imp:

I have the data already loaded into a dataview. It is a UD table, so I cannot use the Reusable Combo.

I might just go the BAQ route, but I was hoping to figure out how to do it without having to create a BAQ. I am probably just missing something stupid, but…

5

I just got a combo working with a UD table using reusable combo:
Screenshot 2024-05-30 164525

Screenshot 2024-05-30 164551
Screenshot 2024-05-30 164551380×511 4.66 KB

Maybe that can work for you?
I also could not figure out how to get it working from a dataview…

4 Likes
6

Is there a reason you are using a UD table instead of User Codes?
(I ask because I’ve seen people create a UD table just for a list of ID’s and Descriptions, and User Codes are a better choice for that and work nice with combos)

7

I will give it a try

8

Yes, I am trying to create a part creation prompt with multiple dropdowns that will check if the part already exists and also standardize the description. I need more than just a single list

9

Wow! Thanks for the tip, it works great. Was not even what I was looking for, it’s even better.

1 Like
10

Brilliant! I’m adding a 4th type to my notes.

1 Like
11

Thanks this was a big help!

2 Likes