Small and medium business | Business Central, N...

Filtering Lookup entries based on selection in header

(1) Share

Report

Posted on by Chris Brill

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:

Dynamics 365 Business Central

All responses (3)

Answers (0)

Chris Brill 96 on at

Like (0)

Report

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)

https://yzhums.com/5985/

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 81,360 Super User 2025 Season 1 on at

Like (0)

Report

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)

https://yzhums.com/5985/

Thanks.

ZHU
Suggested answer

Community member 13 on at

Like (0)

Report

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.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-set-relationships-between-tables

Community site session details

Filtering Lookup entries based on selection in header

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Jonas ”Jones” Melgaard – Community Spotlight

Kudos to the March Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

Filtering Lookup entries based on selection in header

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Jonas ”Jones” Melgaard – Community Spotlight

Kudos to the March Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates