Splliting a table and maintain links.

R

Robert Harrison

I'll simplify this from the actual situation that I have, but it will show
my problem.

I inherited this table so don't blame me :)

TABLE1

ID Autonumber
PARENT Text
CHILD Text

I need to split this into two tables.
TABLE2

PARENTID Autonumber
PARENT Text

TABLE3

CHILDID Autonumber
CHILD Text
PARENTID Long

I need to be able to link the PARENTID Fields. This is what I have done.

I split the tables as shown above. Everything works, EXCEPT I can not
change the PARENTID in TABLE2 to Autonumber. I can add an autonumber column,
but then it numbers from 1 on up and I will lose the linking that I need. I
could use programming add a PARENTID to each table2 record, but I would
really rather use the autonumber. Is there anyway to accomplish this.

Bob
 
R

Robert Harrison

Duh, never mind, I figured it out. I can temporarily link on the old TABLE1
ID and dump the new TABLE2 PARENTID into the TABLE3 PARENTID. Then relink
the tables.
 

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

Excel - Wich Function should I use? 1
One-to-One Table keys 9
Autonumber field in Excel that behaves the same as Access 0
Automatically insert a foreign key into a table with a one-to-manyrelationship 16
Automatically insert a foreign key into a table with a one-to-many relationship 5
Deleting duplicate parents and grouping children to single parent 3
Group By Calculations and Labeling 2
Combo Box in a Datasheet Form 2

Top