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


The problem I am having is that when I do the replace command, All of the records in the table get replaced with the first value in the other table. When what I need to do is match the locations and when they match replace one field for the matching location. i am not sure if this is any clearer.