web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... business central table...

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

Suggested Answer

business central table relation ship use where condition

(0) Share

Report

Report

Posted on by HADIL

20

Here is an example

TableRelation = IF (Type = CONST(Item)) "Item Unit of Measure".Code WHERE("Item No." = FIELD("No."))

ELSE

IF (Type = CONST(Resource)) "Resource Unit of Measure".Code WHERE("Resource No." = FIELD("No."));

but how can i use "<>" equal

WHERE("Item No." <>= FIELD("No."))

Here is an example

TableRelation = IF (Type = CONST(Item)) "Item Unit of Measure".Code WHERE("Item No." <>= FIELD("No."))

ELSE

IF (Type = CONST(Resource)) "Resource Unit of Measure".Code WHERE("Resource No." <>= FIELD("No."));

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Bilal Haider 414 on at

Like (0)

Report

Hi,

May be someone else can give a solution but as per me with TableRelation property it is not possible. But you can use AL code to achieve this.

Was this reply helpful? Yes No
Suggested answer

Andy Sather on at

Like (0)

Report

Hello - We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist. If you need assistance with debugging or coding I would recommend discussing this on one of our communities.

www.yammer.com/dynamicsnavdev

dynamicsuser.net/.../developers

I will open this up to the community in case they have something to add.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 2,606

#2

YUN ZHU 931 Super User 2025 Season 2

#3

Jainam M. Kothari 773 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans