Notifications
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 2,785
Jainam M. Kothari 1,007 Super User 2025 Season 2
YUN ZHU 948 Super User 2025 Season 2
