Integrating two point layers into one

I have 2 point layers with the same table definition. One of the layers has the correct spatial location of the features (layer A), one layer has the correct tabular attributes (layer B). The layer with the correct tabular attributes also has new/additional features as well. So, what I need to do is "move" the points from layer B to the location of the points in layer A based on an ID in the table. The integrate tool will not work because it uses location proximity to move the points. Do I need to do this task programmically or can I do it using the tool box?

The spatial adjustment toolbar has an option that you can either transfer attributes AND geometry or just attributes. It's been a while since I've used it, but I think its a point by point manual type of operation,so depending on your situation, it may or may not be the way to go.

You can do this quite quickly with the field calculator, follow these steps:

1. Add an X and Y field (type Double) to Layer A
2. Open the attribute table for Layer A, right-click the X column heading and select Calculate Geometry.
3. Repeat for field Y.
This has added the point coordinates to the spatially correct layer.

4. Join Layer A to Layer B using you ID field
5. Open the attribute table for Layer B
6. Right click the LayerB.Shape column heading and select Field Calcualtor
7. Tick the Advanced box and copy the code below into the Advanced window (you may need to change 'LayerA' and 'LayerB' to the appropriate layer names).
8. put pNewPoint into the box below the advanced window
9. Click the OK button.
This should now update LayerB points so that they are in the same location as those from LayerA

Remember to back up you data before hand.

Hope it helps,
Miles.