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