Regarding lookup In NAV 2018

bharathnan

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.


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

sorenhinrup

In the table relation for the new field, you can setup which field it should return, as following: