Query to bring back description on UDF instead of Value
Experts,
I need to create a query to show the Description instead of the Value on a UDF on a Service Call.
Please see attached UDF field data and that it is setup that the Value is 1,2,3,4 and the Description is 303952,5836072-4 ect.
It is this 303952 that the query needs to return.
Select T0.[CallID], T0.[U_NBS_S_05]
I tried to get the UDF1 table, but could not link this in the query generator.
Any help would be greatly appreciated.
Regards,
Marli
Query_results.png
(80279 B)
UDF_Field_Data.png
(73508 B)