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

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (4)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

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

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

Stefano Demiliani 37,162 Most Valuable Professional on at

Like (0)

Report

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

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

Check here:

jetsupport.jetreports.com/.../219402227-Using-NL-Lookup-
Community Member Microsoft Employee on at

Like (0)

Report

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

Hi, Thanks for the reply. I am using Jet reports to pull data from the NAV tables so I'd say more yet report.
Stefano Demiliani 37,162 Most Valuable Professional on at

Like (0)

Report

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

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