Regarding a lookup field

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

Answers

  • rfajdigarfajdiga Member Posts: 40
    On that new field Table relation with filter does not help?

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

    x31ioaa4571c.png


    qqu68ows4i7i.png



  • bharathnanbharathnan Member Posts: 92
    thanks for your reply,
    Nope..Its not working out ,I tried it out .
    Its just showing all the dimension valueso0dc7gynu0sx.png

    I just want the highlighted part to be in the lookup.
    Please advice
    Warm Regards
    bharath.k
Sign In or Register to comment.