Dynamics Community Forum Thread Details

How to insert a record in a page whose source table is temporary?

Hi All,

I have a requirement that whenever a Sales Quote is created : For a particular value in Code in "Dimension" Table a new Code value(which is the largest value code + 1) should be inserted in the "Dimension Value" table.

So after creating a Sales Quote For the Dimension = Project, In the 'Dimension Value' table new Code value(P00001+ 1 = P00002) should be inserted :

Till here i have sucessfully completed , i need help in the last part of this requirement :

This newly inserted code should be automatically added in the Sales Quote created.

When you go to Sales Quote > Quote > Dimensions

An Edit Dimension Set Entries page opens up :

I want this page to automatically updated with the new Dimension Code created mentioned above like in the below screenshot :

This above image, i have manually selected to show how it should look like.

I tried to insert in the pages table, but its not geting inserted, the problem is the table for this above page is : Dimension Set Entry. The source table of this page is temporary.

So can anyone please help me how this page can be automatically populated with the new code as soon the Sales Quote is created?

Thanks in Advance.

Quick Links