Notifications
Announcements
HI,
is it possible to use a "Temporary table" in a table relation in Business central ?
Thanks,
Nishan
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.
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
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 2,164 Super User 2026 Season 1
Dhiren Nagar 1,242 Super User 2026 Season 1
YUN ZHU 1,197 Super User 2026 Season 1
