Sorry, I misunderstood what you meant. Yes, I would definitely have a CA for the header and another CA for the details. As long as both use the same connection [DataSource], and transactions are set to manual, they will be part of the same transaction.
You can update more than 1 table with 1 CA as long as get all the properties defined for both tables. However, I like the 2 CA approach for this.
>Dont you need one CA for the header (customer data) and one CA for the details, and both participating in the same transaction, or can we update two tables (invoice header and invoice lines) with one CA (by joining the two tables) ?
Mark McCasland
Midlothian, TX USA