I have a table that is indexec on location. I want to replace the data in 2 of the fields with data from another table that is also indexed on location. Can I use the replace command for this or must I write some sort of procedure to do this. thanks for the help.