Copying heirarchical structures

  • Thread starter Thread starter Amy Blankenship
  • Start date 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
 
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.
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Structure for a Publications database 1
VBA: How can I use a string variable as autofilter criteria? 4
Filter lookup based on field value in current record 3
Two autonumber fields in one table possible? 12
store multiple selection of list box in table field 3
Listbox will not Requery AfterUpdate 5
Filter suggestions in form 4
Data in data sheet to fields in another table 1

Back
Top