You have two Custom Data Types (CDT): ACME_invoice and ACME_invoiceItem that have a flat relationship.
The invoice item table has a field that is a foreign key to the invoice table. You are leveraging the database to automatically generate their primary keys.
How should you structure the process model to add a new invoice and the new invoice items to the system?
When dealing with related data types where one has a foreign key to another, you must first create the record in the primary table (ACME_invoice) and then use the generated primary key to create related records in the secondary table (ACME_invoiceItem). This is why you first write to the ACME_invoice table, then update the foreign keys in a Script Task, and finally write to the ACME_invoiceItem table.
Appian Documentation: Relational Databases
Carlene
4 months agoJutta
4 months agoMauricio
2 months agoGilberto
3 months agoDaron
3 months agoJarvis
3 months agoTony
4 months agoJoseph
3 months agoPansy
4 months agoHuey
4 months agoAlberto
4 months agoAlayna
4 months agoYvette
3 months agoGerry
3 months agoStephane
4 months agoErnest
4 months agoOretha
4 months ago