Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Inserting to 2 related tables with Primary Key Autonumber

Status
Not open for further replies.
addled

addled

Programmer
Dec 19, 2007
1
GB
I have 2 related tables in a one-to-many relationship, where the foreign key in the many table is based on the other table Autonumber primary key. If I want to write concurrently to the 2 tables, how can I identify the value of the primary key autonumber to be placed in the related foreign key, or is it not possible?
Help gratefully appreciated!
 
Status
Not open for further replies.

Similar threads

MrStohler
  • Locked
  • Question
Beginner Q: How to separate data from Excel into related tables and maintain relationship? 1
Replies
5
Views
374
SkipVought
S
JayRo71
  • Locked
  • Question
Saved Imoorts problem with file name
Replies
10
Views
463
Andrzejek
Andrzejek
JayRo71
  • Locked
  • Question
Importing only unique records from excel tables 1
Replies
10
Views
523
SkipVought
S
TrekBiker
  • Locked
  • Question
Using old IDs as Autonumbers 1
Replies
6
Views
417
Andrzejek
Andrzejek
puforee
  • Locked
  • Question
Best way to setup tables for multible related data sets
Replies
1
Views
300
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top