<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Exchange Server">
<!-- converted from rtf -->
<style><!-- .EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000 2px solid; } --></style>
</head>
<body>
<font face="Calibri" size="2"><span style="font-size:11pt;">
<div>OK, I am misunderstanding something.</div>
<div> </div>
<div>I have a map layer of the Public Land Survey System (PLSS) with the Township, Range and Section (TRS) for the whole state.</div>
<div> </div>
<div>I have an Excel table with company names and their associated Township, Range and Section (TRS).</div>
<div> </div>
<div>I want to join the company table to the PLSS layer, so that each section that a company (or multiple companies) is/are located in is highlighted.</div>
<div> </div>
<div>Two problems keep coming up.</div>
<div> </div>
<ol style="margin:0;padding-left:36pt;">
<li>The join seems to find the first company that matches the PLSS TRS then ignores any other companies in the same TRS.</li><li>One of the companies keeps coming up twice in the resulting join with the same TRS (don’t know if it is significant, but it is the last company in the Excel list). I checked and it is only in the Excel table once.</li></ol>
<div> </div>
<div>So I start with 43 companies, and end up with 39, including the duplicate, in the joined table.</div>
<div> </div>
<div>So the question is, how to do a join with a one (target table) to many (join list) relationship????</div>
<div> </div>
<div> </div>
<div><font face="Brush Script MT" size="5"><span style="font-size:20pt;"><b> -- John</b></span></font></div>
<div><font face="Brush Script MT" size="5"><span style="font-size:20pt;"> </span></font></div>
<div> </div>
<div> </div>
</span></font>
</body>
</html>