Please be aware that I'm not used to SQL Server scripts, but perhaps I could use something like the following. (There's quite a bit of guessing here.)

The intention of the following SQL is to create a record in ADDRESS, then add the PROJECT record, referencing the ADDRESS record with its identity.

INSERT INTO [ADDRESS] ([CLIENT_NAME], [ADDRESS1])

VALUES ('ABC CORP', '50 Langridge St.');

INSERT INTO [PROJECT] ([PROJ_NUMBER], [PROJ_NAME], CLIENT_ADDR_ID])

VALUES ('A445566', 'My Project Name', SELECT SCOPE_IDENTITY());

GO

COMMIT

Is this likely to work? How would I modify it if I had to add two ADDRESS records?

Andrew