News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Table relation from a ...

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

Answered

Table relation from a Temporary table

(0) Share

Report

Report

Posted on by Nishan80

290

HI,

is it possible to use a "Temporary table" in a table relation in Business central ?

Thanks,

Nishan

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

YUN ZHU 79,370 Super User 2025 Season 1 on at

Like (0)

Report

RE: Table relation from a Temporary table

Hi, In this case I recommend using Onlookup Trigger.

Before using Page.RunModal() Method, insert some data you need into the temporary table.

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/page/page-runmodal--method

Hope this will help.

Thanks.

ZHU
Suggested answer

Inge M. Bruvik 999 Moderator on at

Like (1)

Report

RE: Table relation from a Temporary table

Not unless you do it in the same database transaction where you put data in the temp table.

And that is something you can only do in code. In the user inferface you would not be able to use a temp table for relations.

Data in temp tables exists only in memory during the span of your transaction.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 293,280 Super User 2025 Season 1

#2

Martin Dráb 232,034 Most Valuable Professional

#3

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans