This was the first thing I tried, and would be my first choice.
However I may have some fundamental misunderstanding of how to add a UD Table as a FKV
to a form in classic. (or Kinetic)
Searching the forum yielded the same sentiment.
So for UD Tables you have two easier choices, 1 Bring in UD table as a Child this gives you full CRUD into the UD table.
Or you can use a BAQDataview (read only)
In your case since you want to manipulate it you should go with UD Table as a child.
There’s a customization wizard that helps you do that. (not the FKV menu)
How the hell did I miss that ?
I guess ahem… I’ve been up my backend so much I forgot how to work the frontend.
That little wizard is quite nice and super powerful it generates something like 11 thousand lines of code all of which you can manipulate slightly to accomplish some quite awesome EpiMagic.
If you wanna get really fancy you can then bring children unto those children I have a Scsreen that is
Regular + UDXX Child + UDXX Child + UDXX ChildA (children of the children) and @Banderson loves the fact that I also stored different types of records in the same UDXX based on a “flag” so the same table can be the child of the same parent 3 different ways
Looking at it, that’s about what it feels like 
And then I have to listen to him whine about why the database is slow…
1 Like
I’ve done the same, but only on tables that are used for more config, or one-off types of data.
Edit: Not the second part of that sentence.
“I crashed our Epicor server and now the contractor is locked in side” Isn’t something you want to be saying
You left out the part where it codes it wrong, doesn’t do what you configured, and
I’ll have to edit the crap out of it.
I’m not sure this is what I want.
Yeah… there are a couple of tweaks you’ll need to do. But it gives you a way to put a dataview in there.
Or you could just customize a UD screen and have management use that.
It doesn’t really matter if that doesn’t work. I have the knowledge now anyway.
I think there is enough information in all your comments to see how I need to approach it.
I’ll update y’all when I do something interesting.
Thanks to everyone for the insights, and if anybody has anything else to add, feel free.
The wizard does work you jsur have to remove the extra keys from the where clause is not that bad
Not completely, in the wizard I mapped EmpBasic.EmpID to UD10.Key2, and the wizard
generated code for UD10.Key1 mapped instead.
Hmm I stink you where drunk (or maybe they broke something) the mapping generally works though Epicor assumes other keys will also be mapped
I agree.
Either is possible
1 Like