Splliting a table and maintain links.

[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

 

[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.