Hey All,
So I’m pretty new to UD tables and was wondering how i can link a UD table to the Part table. The person before me created a UD table with a few values and added that as a dropdown to Part Maintenance. I need to create a BAQ that pulls part numbers based on what dropdown was selected. None of the columns are labeled so its all Key1 Key2 ect. The only values in the UD table are Company and the Custom tags that were entered (It was used to identify parts on an LTA). How can I link(UD01) to the part table so I can make this query?
1 Like
You need to link Company-> Company and PartNum → KeyXXX where KeyXXX is the PartNumber that is stored in the UD table.
2 Likes
So right now i dont believe the part number is stored in the UD Table. How can i do that?
How do you choose the part numbers based on your drop-down criteria?
If you just want to update your UD table, you will need to setup an updatable BAQ. You can do most of the simple updates right from the BAQ designer. But if you need to edit lots of records at once, then you are looking at an advanced BPM. Both methods are doable, it all depends on how you link things up.
Link the UD table and part based on whatever is the common field between the two, which in your case looks like it is the tags.