value of a user field from another user field

[Former Member]

I fill a UDF with a formatted query, but another UDF is dependent on the first UDF value. And try to fill with another query:

SELECT T10.CodSubProceso,

T10.SubProceso

FROM (SELECT T0.U_CodSubProceso 'CodSubProceso',

T0.U_SubProceso 'SubProceso'

FROM [@PROCESOS] T0

WHERE T0.U_CodProceso = SUBSTRING(OWOR.U_Proceso,1,4)) T10

WHERE T10.SubProceso = '[%0]'

I get the following error:

Table not found 'Querys Catagories' (OQCN) (ODBC-2004) Message (131-183)

Sorry my english is very limited, thanks in advance.

Oscar.

[Former Member]

HI...

I think u want to capture data in a user field from the current value of another user field

if this is the case then try $[$ U_anotheruserfield]

[Former Member]

FMS could only be assigned to a specific screen form. Only general description may not be enough for creating the correct query.

[Former Member]

Try this one:

SELECT T0.U_CodSubProceso,T0.U_SubProceso 'SubProceso'
FROM [dbo].[@PROCESOS] T0, dbo.OWOR T1
WHERE T0.U_CodProceso = SUBSTRING(T1.U_Proceso,1,4) AND T0.SubProceso = '[%0]'

However this is not an FMS query. Try to explain what you need to achieve in which screen.

Thanks,

Gordon

[Former Member]

depending on the value of the first field to reduce the number of options for the user in second field.

Oscar