Inserting into linked tables

Results 1 to 2 of 2

Thread: Inserting into linked tables

  1. #1
    Join Date
    Dec 1969

    Default Inserting into linked tables

    I have 2 tables linked by a foreign key in an Access database. I'm using a form to pass values into my sql statement for execution. I'm using INSERT INTO table1 INNER JOIN table2 on table2.Field1=table1.Field1 (Field1, Field2, Field3)....with a values clause following. If there isn't a simple solution, perhaps you could point me in the right direction for updating linked tables using ASP/VBscript in an Access database. Many thanks.

  2. #2
    Join Date
    Dec 1969

    Default RE: Inserting into linked tables

    create an stored selectquery and join the tables using an Inner Join (no other joins allowed), then update that query. <BR>(At least this works in SQL Server, I think it should work in Acces as well) <BR><BR>Keep in mind that when you are using an WHERE clause in that query you can&#039;t update anything that would confilct with the WHERE statement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts