I’ve been fighting populating selection lists with User Codes all last week. I ended up creating BAQs to select the User Codes I want, creating empty Data Views and populating them with a chain of BAQ calls using the kinetic-baq widget attached to the BeforeInitialize event.
I think something is broken in App Studio, because as soon as you add a 2nd reusable combo for User Codes with a different CodeTypeID, Kinetic blows up. I was getting the data from my 2nd User Codes call overwriting the data in the data view for the 1st. BAQs solved it.
Okay, I had to fight with this a bit.
The biggest takeaway is make sure everything is initialized before the control is painted. So, load data into all of your views (source and target) on load otherwise it gets cranky.
Also, take out the Target Desc Col field.
Here’s my setup which takes the list from a BAQ view and puts it into a TransView variable.
I should also point out that when you make selections and you have it set up to be a view, it’s going to save it to that view vs what you have in the epBinding.
** You can move the Source View Name to the Source Table Name too, I guess.
Also, if you’re populating data from the same table, you can omit the Source/Target Tables and just populate “Table Name.”