How can I use a parent key for a few record in multiple databases?

Expert Answer Center > Experts On Demand > View Answer

EMAIL THIS

Experts on Demand

EXPERTS ON DEMAND HOME

POSE A QUESTION

VIEW ANSWERS

BROWSE BY TOPIC

RSS FEEDS

I have four databases that are linked with foreign keys. I want to be able to write a new record in two databases, but have the foreign key in the parent set to the child database ID field. The child ID field is an autonumber field. I want to be able to do this in access and in SQL. I am using SQL commands.

QUESTION POSED ON: 29 JUL 2005
QUESTION ANSWERED BY: Rudy Limeback

Have a look at this article: @@IDENTITY crisis. This should get you started.

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 2009, TechTarget \| Read our Privacy Policy