query to Update data to foreign key field?

[pablavo]

I've sent a post about this before and got some of the answer from 'Dennisk'- thanks.

I want to replace composite keys with a primary. I've just made an autonumber field on one table for my new primary key and already populated it. On the foreign table ive made a new field with 'number' datatype; this field is empty at the moment.

I'm not sure how to update the foriegn tables new field with the primary tables data. I've saw it before and remember it being easy, just can't remember how to do it.

I obviously want the numbers in the primary key field to relate to the correct records in the foriegn table.

Anyone know what the query is or if there's another way?

Thanks

 

[Dennisk]

pablavo,

Create an Update query and link on the old composit key. Update the New Fk with the Primary key from the One side of the relationship.