Skip to Content
0
Former Member
Dec 26, 2007 at 09:43 AM

Problem in Formatted Search

25 Views

I have added two UDFs namely ItemCode and ItemName on header level of Profit center form.

I have attached folwing query to ItemCode for Formatted Search

select Itemcode from oitm

I want to display the corresponding itemname automaticaly in itemname field. So I created the folowing query:

Select oitm.itemname from oitm where itemcode= (select $[$U_ItemCode.U_ItemCode])

setting is that Auto refresh when field changes (ItemCode).

Now what result I am getting is as follows:

if I change ItemCode and goto ItemName, the itemname should change automaticaly, but it doesn't happen. However if I press Shift+F2 here on ItemName it takes the correct ItemName. I want that ItemName should be changes as ItemCode is changed automaticaly...

I am using a Patch 01.

plz help