Skipping a record when joining tables

289
1
07-21-2014 07:54 PM
LoganJackson
New Contributor

Here is the scenario:  I am creating line segments between points to represent human migrations from place to place over time.  Each point is attributed with City, State, Year, Lat, Long, etc, etc.  What I am trying to do is join the point attributes to the newly created line segments.  The trick is I need to join line segment 1 with point 2.  Essentially line 1 needs the "Destination" attributes, not the "Origin" attributes.  However, when I go to join the tables I can't join line 1 with point 2.  It joins line 1 with point 1, thus giving the attributes from the origin point instead of the destination point.  This might be confusing, so here's the example:

Points Table

FID     ID     Event     City_Town     State     Country     Year

0        1      Begin     Seattle          WA          US          1986

1        2      Move      Helena          MT           US          1988

2        3      Move      ...

Line Segments Table

FID

0

1

2

Is there a way to join Line Segment FID 0 with Point FID 1?  When I try to join the Lines Table FID with the Points Table ID a null record is added so that the tables line up at 1.  Any way around this?  Thanks.

Tags (1)
0 Kudos
1 Reply
DanPatterson_Retired
MVP Esteemed Contributor

you could simply add fields to the existing tables that reflect the pairing you want.  There is an example towards the bottom of this help file link called autoincrement and you can adjust the start number accordingly between the two files.

0 Kudos