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 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

292

HI,

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

Thanks,

Nishan

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Suggested answer

Inge M. Bruvik 1,161 Moderator on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

YUN ZHU 98,128 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

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,033 Super User 2026 Season 1

#2

Dhiren Nagar 1,105 Super User 2026 Season 1

#3

YUN ZHU 1,035 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans