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... Table relations by code

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

Suggested Answer

Table relations by code

(0) Share

Report

Report

Posted on by Community Member

Hello all,

I have created a field that has a table relation on the Purchase header. But now it can be that the displayed purchase order is archived and thus the field is emptied.

How can I tell the system to execute one Table Relation for one value and the other Table Relation for the other value, depending on a condition? I want one Table Relation to go to the orders and the other to the order archive,depending on which condition is true?

Thank you ;)

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Greg Enns 1,122 on at

Like (0)

Report
Copy link

Link copied!

You would need another field on the current record, to indicate if the Table Relation should be to the PurchaseHeader or PurchaseHeaderArchive. For example, the field could be a boolean called "IsArchived".

You should be able to follow the pattern used for the "No." field on the PurchaseLine table. The "Type" field is the indicator that adjusts the Table Relation for the "No." field.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

OussamaSabbouh 1,796 Super User 2026 Season 1

#2

YUN ZHU 965 Super User 2026 Season 1

#3

Teagen Boll 664 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans