News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Table relation or look...

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

Suggested answer

Table relation or lookup with multiple conditions and tables

(1) Share

Report

Report

Posted on by Pragya752

210

I have a scenario with two tables A and B ,where I have to provide a lookup or table relation of table B in table A but the catch is that only those records should be visible in lookup which are not already present in table A and its posted table , say table C. How can I do it?Is there any other way to achieve this.I tried settableview but Filtering records before trigger onvalidate is not happening.

Categories:

Dynamics 365 Business Central

Dynamics 365 Business Central

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 75,848 Super User 2024 Season 2 on at

Like (1)

Report

Table relation or lookup with multiple conditions and tables

Hi, I may not fully understand your question, but in the TableRelation property you can specify different tables based on conditions.

Hope this helps.

Thanks.

ZHU
Suggested answer

gdrenteria 13,057 Most Valuable Professional on at

Like (0)

Report

Table relation or lookup with multiple conditions and tables

Hi

You may need to customize the lookup.

Here some information.

Dynamics 365 Business Central: How to create a Lookup, Drop-Down, or Option list (Single and Multi select) | Dynamics 365 Lab (yzhums.com)

BR

GR

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2

Martin Dráb 230,458 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans