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 ?