changing the primary key (1 Viewer)

[maravinds]

Hallo Everyone,

I have two tables(table1, table2) in the database.

Relationship between table1 and table2 is one to many.

The problem is that in table1, the primary key (reference to table2 for the relationship) is wrongly defined. now i need to change the primarykey values and by changing them i need to change the values in the table2 automatically.

is that possible or not? and moreover the problem is that i have morethan thousands of data in each table.


aravind.s

 

[Ron_dK]

You might read this post first :

http://www.access-programmers.co.uk/forums/showthread.php?t=107042