Skip to main content
Business Central forum
Suggested answer

Filtering Lookup entries based on selection in header

editSubscribe (0) ShareShare
ReportReport
Posted on by 2
Hello community,

I'm pretty new in AL programming, so this might be pretty obvious to some of you.
I probably could find a solution just by having redundant data, but I want to find out what is possible in AL and have clean code. I've searched many forums, but couldn't find a fitting solution (or maybe it is really that complicated).

For the sake of better understanding I'll use a made up setup.

I have 3 (custom) tables:
1: /Bin/ (/Bin No./, Name, /Allowed Item Type/ [fruits, vegetables, sweets,...])
2: /Bin Item List/ (/Bin No./, /Custom Item No./, Amount/)
3: /Custom Item/ (/Custom Item No./, /Custom Item Type/ [fruits, vegetables, sweets,...])

I have 2 pages:
1: /Bin Header/, Document, linked to table 1
2: /Bin Item List/, List Part, linked to table 2 and Subpage of /Bin Header/.

I want the lookup for new items in the /Bin Item List/ to only contain those items with /Custom Item/./Custom Item Type/ = /Bin/./Allowed Item Type/. 

Is there a nice way to just add an additional filter without writing a new lookup page or something like that?

Thanks in advance and have a nice day
Christopher 
Categories:
  • Chris Brill Profile Picture
    Chris Brill 2 on at
    Filtering Lookup entries based on selection in header
    @User:
    I'm not quite sure whether I understand your table design - but try setting a TableRelation on table 2, field Custom Item No.
    Thanks, I'm already using a table relation, but I'm looking for an easy way to add an additional filter that is depending on a variable or a return value of a function. As far as I've tried, none of the WHERE <TableFilters> - options FIELD, CONST or FILTER can handle this. 
     
     
    @YUN ZHU:
    How to create a Lookup, Drop-Down, or Option list (Single and Multi select)
    Thank you, that would solve the problem. It just seems to be so much effort (create a new page which still needs to call another function to get the filter value, create a new trigger...) for such a simple thing as adding a where statement. And there wouldn't be a table relation so this could cause problems in case of rename cascading, right?
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 59,873 Super User on at
    Filtering Lookup entries based on selection in header
    Hi, hope the following helps.
    How to create a Lookup, Drop-Down, or Option list (Single and Multi select)
     
    Thanks.
    ZHU
  • Suggested answer
    Community member Profile Picture
    Community member 13 on at
    Filtering Lookup entries based on selection in header
    I'm not quite sure whether I understand your table design - but try setting a TableRelation on table 2, field Custom Item No.
     
     

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,030 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,562 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans