Adding linked records

  • I need to add records to a DB in SQL Server 2005.

    Each composite record represents a project in the table PROJECT, with client and agent addresses in the table ADDRESS, with foreign keys Client_addr_id and Agent_addr_id and primary key Addr_id in ADDRESS.

    Can someone show me how to add the composite record in one transaction, please?

    (I'm doing this from Access 2007 using DAO/ODBC, but presumably that doesn't make much different to the principles of what I'm trying to do.)

    Andrew

  • You don't need to duplicate your posts 😉

    http://www.sqlservercentral.com/Forums/Topic1375152-1292-1.aspx

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply