Regarding a lookup field

bharathnan

Hi all,
I created a field in sales header part very much like responsibility center in the header part.When ever we click on to the lookup the responsibilty list is opened but in my field i gave source table as dimension value ,So here i want the dimension values of AREA only to lookup in my field ,I tried using the filters in the properties ,Is there any way to solve the issue.

Any help would be appreciated.
Warm regards,
bharathk

rfajdiga

On that new field Table relation with filter does not help?

"Dimension Value".Code WHERE (Dimension Code=FILTER(AREA))

bharathnan

thanks for your reply,
Nope..Its not working out ,I tried it out .
Its just showing all the dimension values

I just want the highlighted part to be in the lookup.
Please advice
Warm Regards
bharath.k