INSERT INTO AD_Account (AcctName, AcctAddress, AcctCity, AcctState, AcctZIP,
AcctStart, ListID)
VALUES ([AcctNameVal], [AcctAddressVal], [AcctCityVal], [AcctStateVal],
[AcctZIPVal], [AcctStartVal], [ListIDVal])

INSERT INTO AD_AcctContact (ContactFName, ContactLName, ContactTitle,
ContactTel, ContactEmail, ContactStart, AcctID)
VALUES ([ContactFNameVal], [ContactLNameVal], [ContactTitleVal],
[ContactTelVal], [ContactEmailVal], [AcctStartVal], @@IDENTITY)

Where everything in brackets is a properly typed value.

This does work. If table AD_Account has an identity column, the value of
the newly created row will be available as a variable in the second
insert.

Gert-Jan


[quoted text, click to view]