Update table from a column in another table

[guitarzycki]

Name: Capture.PNG  Views: 8  Size: 109.9 KB  ID: 30293" class="thumbnail" style="float:CONFIG" />Greetings! I've got what I thought would be really easy at first, but is stumping me. Part of it I now know was due to a rookie mistake. I created a tool assemblies table and a separate one for assigning components using a unique ID field as the primary key that was also the tool naming convention we were using. Well, the trouble now is that we have changed our naming convention and I need to update the components table to reflect this. I have created a new column in the parent table and given all the assemblies a new unique ID. I also created a foreign key column in the child table. The question is, how do I use an update query to update the new id number in the child table where it matches the old id number from the parent?

Any help is appreciated!
Thanks,

[ranman256]

make an extra field OldID
update all the old IDs to this field.
now you can reference both old and new id's.

[guitarzycki]

No way to use an update query to do this? The reason I'd like to update the old with new is so that I can still display the new numbers assigned to the old in the forms.

[guitarzycki]

Desired change

[guitarzycki]

Thank you for your help on this. I figured out where I went wrong in trying to update these. I changed the relationship too early. As soon as I changed it back I was able to create an update query and it all worked out.