Lookup field in nav 2009

(0) Share

Report

Posted on by bharathkarunakaran

475

2018_2D00_02_2D00_08-21_5F00_59_5F00_56_2D00_CRONUS-USA_2C00_-Inc.-_2D00_-Microsoft-Dynamics-NAV-Classic-_2D00_-_5B00_Shortcut-Dimension-0-_2D00_-Dime.png

Hi guys ,

I have an issue in lookup for field.

I created a new field in sales header and i gave lookup to dimension of area code but when i click on the lookup its showing all the fields that are present in that dimension value list .I have changed the properties if that field also but it doesn't seems to work.

Please advice

*This post is locked for comments

All responses (7)

Answers (0)

Suggested answer

4BzSoftware 6,071 on at

Like (0)

Report

RE: Lookup field in nav 2009

Hi bharath,

It looks like there are C/AL code in OnLookup( ) triggers of Table or Form. You should modify the code to filter in this case.
bharathkarunakaran 475 on at

Like (0)

Report

RE: Lookup field in nav 2009

Thanks for your reply.

I solved the Issue.

Warm Regards,

Bharath
Ghetz 2,983 on at

Like (0)

Report

RE: Lookup field in nav 2009

pleasae Send a screen of your table where we can see all the field names and values, with the sample containing "AREA" as data
bharathkarunakaran 475 on at

Like (0)

Report

RE: Lookup field in nav 2009

Yes,It is what you said.

But even after that it showing all the dimension value in dimension value table.

Please advice
Ghetz 2,983 on at

Like (0)

Report

RE: Lookup field in nav 2009

Does not make much sense:

"Dimension Code".Code WHERE Code=Filter(AREA)

Do you mean?

"Dimension Code".Code WHERE Dimension Code=Filter(AREA)
bharathkarunakaran 475 on at

Like (0)

Report

RE: Lookup field in nav 2009

Please advice
Ghetz 2,983 on at

Like (0)

Report

RE: Lookup field in nav 2009

Show a picture with the properties of your field so we can help you futher