Posting linked records

I was brought up with dBase, and now need advice on how to post linked
records using DAO & SQL. Though I could do a kludge for this, I want to know
to do this simply and efficiently.

I need to use DAO to post to a non-SQL system, where I calculate totals for
a group of detail records, then post this to a header record on the non-SQL
system, followed by detail records taking values from the detail records. I
am OK with posting to the non-SQL system, but want to know how to easily
code the SQL/DAO part.

I used this code to calculate the data for the header records from the
detail records:
SELECT szAccount, szTranRef, dDate, szvalidationComment,sum(dblNetAmount) AS
[dblTotalReceived]
FROM import
GROUP BY szAccount, szTranRef, dDate, szvalidationComment

Many thanks
David

David Bernheim wrote:
> I was brought up with dBase, and now need advice on how to post linked
> records using DAO & SQL. Though I could do a kludge for this, I want
> to know to do this simply and efficiently.
>
> I need to use DAO to post to a non-SQL system, where I calculate
> totals for a group of detail records, then post this to a header
> record on the non-SQL system, followed by detail records taking
> values from the detail records. I am OK with posting to the non-SQL
> system, but want to know how to easily code the SQL/DAO part.
>
> I used this code to calculate the data for the header records from the
> detail records:
> SELECT szAccount, szTranRef, dDate,
> szvalidationComment,sum(dblNetAmount) AS [dblTotalReceived]
> FROM import
> GROUP BY szAccount, szTranRef, dDate, szvalidationComment


Write it as two seperate INSERT statements. Generally, you would create the
header records, and then create the detail records.


--
Regards,

Michael Cole