web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Can I make Jet Option ...
Microsoft Dynamics NAV (Archived)

Can I make Jet Option Lookup based on another Option Lookup?

(0) ShareShare
ReportReport
Posted on by Community Member

Good Morning all,

Could anyone make any suggestions for the below please?

I have created 2 option lookups in my Jet report that act independently. Is there a way to make the options in the 2nd list dependent on the item selected in the 1st list? I.e. We have a hierachy structure for Countries and Cities. So in the table each city has a corresponding country code. I would like to select England in the first option list and then the 2nd option list to only list the cities in England in the table. 

I have set it up in the deisgn to do this but it only works for anything put in as default rather and changing on selection.

Any suggestions would be greatly appricated.

Thanks

Neil

*This post is locked for comments

I have the same question (0)
  • Stefano Demiliani Profile Picture
    Stefano Demiliani 37,166 Most Valuable Professional on at

    Is it a question related to Jet Reports or NAV? If it’s NAV is quite simple (relations).

  • Community Member Profile Picture
    Community Member on at

    Hi, Thanks for the reply. I am using Jet reports to pull data from the NAV tables so I'd say more yet report.

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,166 Most Valuable Professional on at

    Jet Reports is an external tool. However, yes it's possible.

    Check here:

    jetsupport.jetreports.com/.../219402227-Using-NL-Lookup-

  • Community Member Profile Picture
    Community Member on at

    All Sorted now, thanks for you help. This is a great help.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans