Regarding lookup In NAV 2018

bharathnan
bharathnan Member Posts: 92
in NAV Three Tier
Hi,

I have created a lookup field in the Table and I have set the Table relation to my custom table and I want that lookup field to be filter based on the Item nUmber in line to that of item no in the Custom Table and It works fine for me.
bmpmgpeesgia.png

But the issue that I am facing is whenever I click some values in the lookup I want the Variant field Value to be filled instead of the Item No.
Can You please help out and sorting this issue.
I would really helpful for any help with this.

I have attached the screenshot above for your reference.

Regards,
Bharath

Answers

  • sorenhinrup
    sorenhinrup Member Posts: 136
    In the table relation for the new field, you can setup which field it should return, as following:
    yepcpxciwmr3.png

Categories