Line-drawing between points?

[SebastianSchüßler]

Hi,

i use ArcGIS and i have an Map with an lot of points. Every point has an
connection to MS-SQL and obtains thereby attributes.

It exists main- and side points. Each side point is associated with a main point. This
is characterized by an attribute. There are e.g. a main point P1. Each side
point has an attribute "main point". In this example is then written
in each P1. Thus there is a P1 1: n relationship. I would like draw a line
automatically between all mating major and minor points.

How does this most easily directly in ArcGIS, or I have to prepare something in
SQL?

thanks in advance

[ChrisSmith7]

If I understand correctly, you have a many-to-one point association - one main point with one or more minor points. There are a few ways to do this, but the first that comes to mind is the built-in Points to Line tool:

http://resources.arcgis.com/en/help/main/10.1/#/Points_To_Line/00170000003s000000/

Based on your join, you could create a field with unique values as the "Line_Field" - this should create all of your lines based on the relationship described.

Let me know if this works for you!