Skip to Content
0
Former Member
Aug 19, 2008 at 06:33 PM

Dynamically set UDF Category?

89 Views

Does anyone know how to setup a Formatted Search on the UDF Category field that will fire a query automatically when the Item changes?

Example:

The UDF Category on the Item Master needs to correspond to the Item's Item Group

i.e. If the Item is in the Item Group = "Printers" then I want to see the UDF Category for "Printers"

Otherwise, I see the UDFs for other items that don't apply to "Printers"

This query works when I fire it manually with SHIFT+F2, but I can't get it to see when ItemCode changes.

SELECT T0.[ItmsGrpNam] FROM OITB T0 WHERE T0.[ItmsGrpCod] = $[OITM.ItmsGrpCod]

Does anyone know how to do this?

Thanks,

Brad Windecker