Skip to Content
0
May 08, 2009 at 08:13 AM

UDF value lookup

36 Views

When using my field on a offer layout, my UDF field shows the item rownumber instead of the item name.

The query behind the udf field in the offer screen looks like this,

SELECT T0.[Name], T0.[U_ORB_IMO_NR] AS "IMO Nr.", T0.[U_ORB_BOUWNR] AS "Bouw Nr", T0.[U_ORB_EXNAAM] AS "Ex Naam"
FROM [dbo].[@ORB_TBU_SCHEPEN_2]  T0

I added it to my print layout by choosing field source database -> table is offer -> column the UDF.

Also tried with enabling and disabling of the get Description field.

What am I doing wrong ?

Thank you!