python script for using values from one table to add to another

[KatayounMesgarian]

Hi there,

I have got question about how to write a script to grab information from one attribute table and add them to another one. to be more specific,, there are two layers, a point layer with start and end shotpoint IDs (and of course Easting & Northing) and another one which is basically the same data in line format that connect the start point to end point to present track lines, what I need to do is to take these shotpoint IDs from point layer and add them to each single line. I was thinking of using join but it didnt worked out. Is there anyone know how to do it?

thanks a lot
Katy
[ATTACH=CONFIG]21295[/ATTACH]

[markdenil]

You write that join didn't work; was that a table join or a Spatial Join?
The two are quite different animals.

Spatial Join is likely what you want to use.

[KatayounMesgarian]

You write that join didn't work; was that a table join or a Spatial Join?
The two are quite different animals.

Spatial Join is likely what you want to use.

thanks for the reply.

I did use Spatial join, but that still needs some manual editing. I am looking for a way that I can get the information all automatically.