>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.

Maybe I misunderstand you ... When you replace data in some tables you still use index tags of this table, so all new data will be sorted automatically while 'replacing'.