AddNew record to multiple tables

Results 1 to 2 of 2

Thread: AddNew record to multiple tables

  1. #1
    Join Date
    Dec 1969

    Default AddNew record to multiple tables

    Let&#039;s say I have two tables set up in Access. With a relashionshipt between TableOne.PrimaryKey to TableTwo.ForeignKey (e.g. EventID field).<BR><BR>How can I add New record to both tables simultaneously so that TableTwo.ForeignKey will equal TableOne.PrimaryKey?<BR><BR>I can&#039;t find any information on how to do it.<BR><BR>mucho thanks

  2. #2
    Join Date
    Dec 1969

    Default Multiple adds...

    Add a record to the table with the primary key, getting the primary key back in the process.<BR><BR>See the ASPFAQs, category "Databases, General" for info on how to do this.<BR><BR>Use that primary key as you add the record in the other table.<BR><BR>With Access there&#039;s really not another practical way.<BR><BR>

Posting Permissions

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