I have a main page ie; Initiating request page>In the initiating request page, we have three box layouts each boxlayout is from different interface and different datatableThree Box layouts has: 1.Request info interface (Stored in seperate DBtable - Main table for initiation request(AutoGeneratedPrimaryKey)) 2.Request type info interface (Stored in seperate DBtable)- The Auto generated Primarykey value should store for each request type row 3.RequestStock info interface (Stored in Seperate DB table)
> Submit of the interface which has all the three info details
In the Request type info(2), we can add multiple types like 1,2,3 for single request Initiation,Same for Request Stock info(3), we can add multiple types like 1,2,3 for single request Initiation
But After submitting this page only the Auto generated ID will generate for main db table, In this case how can we add this Autogenerated it to other DB table rows(2),(3).
Discussion posts and replies are publicly visible
Hello Anto,in the assumption that you have record types created for each table. Are their ID set as primary?
Yes
how do you store the values? with a single " write record" node for all three?
Iam not using Write Record,
IN PM, Iam using UIT to fill the details need for all the table and Storing using Write to data store entity for all the three table. so now, From these 3 table one of the table's Primary key should store in the other 2 table(We have a column to Store)
so you are still using CDT and Write to data store?Are you using then write to multiple data store?
aaah now i am following slowly. -> the primary key of the first table needs to be set as an output value of "write to data store". update the CDT foreign key values of the other two and store it in a second write to data store node. I recommend for debug reasons to store, update and store again in seperate nodes.