Changing primary key data

[laurenm]

I have a form that I use to update our employees' information including what
assets that are assigned to them. There are two tables: one with employee
contact information and the other with their assets, both linked by an
employee ID which is a primary key int eh employee contact information table.
In some instances I need to change the Employee ID but when I do this, any
assets I have assigned to the employee I change to will "disappear". I have
tried refreshing the data but it does not keep the assets. Is there anyway I
can do this? Any help would be appreciated.

Thanks!
Lauren M

 

[helvetik]

Is this in Excel ?

Do u require to change the ID in only one table and not both ?

 

[laurenm]

I am sorry for not being clear. This is in Access 2002. Yes, I would need the
ID to change in both tables.

Thanks!
Lauren

 

[helvetik]

Let me check it with someone familiar with Access.