By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,509 Members | 2,234 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,509 IT Pros & Developers. It's quick & easy.

Copying records

P: n/a
ken
Hi,
I'm using access 2000. I have a table with a main key and another table
that maps to that key.
Tbl1 Tbl2
*ID Autonum-- *Mykey Autonum
Col1 \--- foreignID Number
Col2 Col1
.. .
.. .
.. .

The relationship is 1 to many.

I need to make a copy of a given record in Tbl1. When I do that the new
record will obiously have a new ID. Lets say the ID was 55. That part
if fine. I just use an append query. Lets say when I copy record ID=55
the copy will have ID=100(this is in Tbl1). The part I can't figure
out is how to make copies of records in Tbl2 so that all the records
with with foreignID=55 will append with ID=100.
I hope this explains what I'm trying to do. I can't figure out how to
get the new ID(of the appended record in Tbl1) for my append query of
Tbl2.

Thanks.

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
ken
nevermind...I got it...found the answer in other posts...
Basically you have to, through DOA add a new record to the Master table
then get the ID. Then use a query to update all the children.

Thanks.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.