Notifications
Announcements
No record found.
*This post is locked for comments
Good day Sakrut,
I am doing this because I have to insert a data in a third table (Table 3), where all the possible combinations between the keys fields of the two tables must be (Table1 and Table2), in addition there are more fields in the third table (Table3) which are calculated values.
Thanks for your help. I'm waiting for your comments
Hi,
can't you use a single cursor on a crossjoin betweem table1 and table2 using only one while select?
Maybe you can combine this (if possible, don't know your calculations) selct with an insert_recordset command to fill table3?
Regards Douglas
Ah, another duplicate thread... :( There is a parallel discussion in the Finance and Operations forum.
Martin, You're right, but I have not managed to delete the post.
:(
Just replied with the same post... The best practice is not to do so.
It's unreasonable to do so like this. If it's an actual requirement, I believe you should be able to solve it by adding relationship between the two tables and make use of query clause.
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.
Martin Dráb 4 Most Valuable Professional
Priya_K 4
MyDynamicsNAV 2
