My previous question was probably wrong in the way i worded it and when i spoke to the requesters that was not what they actually wanted.
They are looking to pull the Customer Part Number from CustXPart table into the Part Entry/Tracker screen as a read only field.
I have added fields from UD Tables as dropdowns on a screen before but never actual DB fields and i seem to be struggling at something which is probably so simple! 
Help me obi-wan-kenobi you’re my only hope…
Are you using classic or kinetic screens? You should be able to do this with a BPM.
Kinetic, i did think about BPM and when i did it on the Landing page i was getting an error previously on the getrows method
I forgot about that, shame those cannot be pulled into the landing page.
I assume that in this case there is -always- only one customer part number per part? If there were multiple customer PNs (e.g., the part is sold to multiple customers, each with a unique customer PN), then you would need to display a table of customer PNs instead of just one additional field per part.
Yes, always unique
That is what i thought but i cannot seem to get it to work. Oh well.
You could
Create another dataview in a new layer populated by a baq that contains the field you want and the fields you need to make it unique ( customer and part number to get custpart?) Have it have the “key fields” as parameters.
create an event " after - on load" for the specific form you would like to display the xref part number and use a kinetic baq to populate the dataview
create a field in the layer bound to the field in your dataview you would like to show
profit?
I did something very similar with success recently.
Form:
