So I know that this is a dumb question, but I can’t find any documentation and I need to get this working quickly.
We have a UD table that needs to be set up with a list. There 3 fields that we have extended from UD07 that I need to populate.
What I am having trouble with it, what do I need to get the fields to initialize? I go to add new, and nothing will stay in the table. I’m sure it has something to do with the key fields. What do I need to set for a new record?
Brandon I am not following what you are trying to do…
To add anything to UD07_UD you need to have a valid UD07 record with at least Key1 populated.
I made a BAQ for UD07. Added the fields that I needed to modify and added Key1. Saved the BAQ
Then I made it updateable, using the UdateExt BO for UD07.
Hit save, and I get this error.
So I added the rest of the key fields. Save with no errors.
Now I go to add new line (the table is empty at this point.) A new line pops up I double click and get the input screen. I add my inputs, shows a dirty line, update, the line goes away.
So if I go to populate Key1, I’m assuming that I do that in the initial expression right?
I add a row, then update.
This after update.
This after get list
What am I doing wrong?
You need all the keys for the udpatable baq to work Company, Keys1-5 and then your custom fields.
edit Now I see the screen shots.
It’s for a third party app, we are using UD tables to make sure we keep everything seperate.
Wait how can get list be empty? Are you adding a new record? If so the Key fields need ot be updatable too.
If you want a dropdown list of values you should use UDCodes instead…
Can’t I just set the initialized value?
I don’t
How are you doing that?
I still can’t add to the list after making the key fields updateable.
Aren’t the UD Entry forms available to use in E10 ?
Yes they are
I’ve never tried creating a new record via a UBAQ… I wonder if its busted…
Where do I find those? I’ve looked but never been able to find them. (hence the UBAQ)
never mind, I think I found it.
So I have to customize the form to make my extended fields show up in there? It seems like it would be easier to make a UBAQ than do that.
Interestingly enough, those rows that I tried to create show up in that screen, but not in the BAQ. I wonder why?
