use data from one table to populate another

[danb]

Hi, just wondering if anyone could help...

I have a table containing details of shops together with their postcodes and two blank columns - one for an easting grid reference, one for a northing grid reference.

I also have a table conatining lots of postcodes with their easting and northing grid refs.

I want to automatically populate the easting/northing rows of the shops table, using data from the grid ref table.

Does anyone know if this is possible in Access 2000, and if so how to do it?

Any help would be fantastic... Thank you very much.

 

[bjackson]

Take a look at this attatchment

 

[Pat Hartman]

You should NOT copy the easting and northing values to the shops table. When you need them, simply join to the zip table to obtain them.

 

[bjackson]

I may have misunderstood the question Pat
I took the question to mean to update the table once-that is transfer the data,but i guess common sense says why would you do that

 

[danb]

Thanks for your help guys. I was indeed needing a 'one-off' insert into the shops table. The reason I don't do it dynamically by joins, is that it is due to be a web application and I'm trying to cut down on processing (there is a sh*t load of data.

I wrote a simple application which has done the job for me. Took ages to run due to the volume of data, but I've got what I want now.

Thanks anyhow chaps.