Copying heirarchical structures

  • Thread starter Amy Blankenship
  • Start date
A

Amy Blankenship

If I have a structure that looks like this:

Course
Category
Topic
Page

What is the most efficient way to copy it? If I simply select the Category
record in the form, will a copy be created where new records are created
pointing to the new Category (with new topic, new Pages), or will the
Category just be copied?

Thanks;

Amy
 
D

Douglas J. Steele

Just the one category record will be copied.

You'll need to copy the topic and page records, remembering to change the
FKs in them to point to the new PKs.
 
A

Amy Blankenship

OK, thanks.

-Amy

Douglas J. Steele said:
Just the one category record will be copied.

You'll need to copy the topic and page records, remembering to change the
FKs in them to point to the new PKs.
Click to expand...
 
Top