Announcements
No record found.
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.
Congratulations to our 2026 Super Stars!
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,033 Super User 2026 Season 1
Dhiren Nagar 1,105 Super User 2026 Season 1
YUN ZHU 1,035 Super User 2026 Season 1