I am trying to use a!writeToDataStoreEntity to write to into a database , if one on the fields is a (foreign key) which is an auto-generated primary key of another table in the "same interface ", how can i pass it to the other table when it hasn't been generated yet?
Discussion posts and replies are publicly visible
or i am obliged to use process models and script task?
You can use a!startprocess() to first write in the first table and then use its primary key in the second table
If you are using 23.2 and lower you'll need to do in with 2 writes wrapped in a Process Model called with a!startProcess. If you are on 23.3, you can simply create a nested Record type with relationships and it will take care of it for you.
You need to do these things inside a process.
Ok, thank you sir. I will try it and if I still face any issue, I will update you by starting my own thread.