<div style="font-family: arial; font-size: 14px;"><div fr-original-style="" style="box-sizing: border-box;">If you want to pursue the joined table approach, I did some searching of my archived projects and found this method of doing a join in the DATA object (with some commented out experiments):</div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;">    CONNECTIONTYPE OGR</div><div fr-original-style="" style="box-sizing: border-box;">    CONNECTION     'T:/GeoData/Parcels/Alberta/t_505033.shp'<br id="isPasted" fr-original-style="" style="box-sizing: border-box;">    DATA "SELECT * FROM t_505033 LEFT JOIN 'ODBC:Parcels_Rural,basic'.basic ON t_505033.PID=basic.PID"<br fr-original-style="" style="box-sizing: border-box;">##    DATA "SELECT * FROM (t_505033 LEFT JOIN 'ODBC:Parcels_Rural'.basic  ON t_505033.PID=basic.PID) LEFT JOIN 'ODBC:Parcels_Rural'.estate ON basic.LINC=estate.LINC"<br id="isPasted" fr-original-style="" style="box-sizing: border-box;">##    DATA 'SELECT * FROM t_505033 LEFT JOIN "ODBC:Driver={Microsoft Access Driver (*.mdb)};Dbq=G\GeoData\Parcels\Alberta\t_505033.mdb".basic ON t_505033.PID=basic.PID'</div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;">I used the ODBC driver because the other table was in an MS Access .mdb.  You may need to do some experimenting to get the syntax for joining a shp file to a dbf.</div><div fr-original-style="" style="box-sizing: border-box;" contenteditable="false"><span fr-original-style="" style="box-sizing: border-box;"> </span></div><div fr-original-style="" style="box-sizing: border-box;">Brent</div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><hr id="previousmessagehr" fr-original-style="" style="box-sizing: border-box; clear: both; user-select: none;"><div fr-original-style="" style="box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="box-sizing: border-box; font-weight: 700;">From</strong>: "Christopher Hughes" <chughes@co.lincoln.or.us><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="box-sizing: border-box; font-weight: 700;">Sent</strong>: 1/6/23 2:11 PM<br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="box-sizing: border-box; font-weight: 700;">To</strong>: GeoMoose Users <geomoose-users@lists.osgeo.org>, "bfraser@geoanalytic.com" <bfraser@geoanalytic.com><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="box-sizing: border-box; font-weight: 700;">Subject</strong>: Re: [GeoMoose-users] One to Many Join - GeoMoose 3</span></div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-class="elementToProof" fr-original-style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); box-sizing: border-box;"><span fr-original-style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); box-sizing: border-box;">Thanks for the suggestion! I hadn't thought of approaching it that way.</span></div><div fr-original-class="elementToProof" fr-original-style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); box-sizing: border-box;"><span fr-original-style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></span></div><div fr-original-class="elementToProof" fr-original-style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); box-sizing: border-box;"><span fr-original-style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); box-sizing: border-box;">Chris</span></div><div fr-original-class="elementToProof" fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" id="Signature" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); box-sizing: border-box;"><span fr-original-style="font-family: "Segoe UI", "Segoe UI Web (West European)", "Segoe UI", -apple-system, BlinkMacSystemFont, Roboto, "Helvetica Neue", sans-serif; font-size: 15px; text-align: start; background-color: rgb(255, 255, 255); display: inline !important;" style="font-family: "Segoe UI", "Segoe UI Web (West European)", "Segoe UI", -apple-system, BlinkMacSystemFont, Roboto, "Helvetica Neue", sans-serif; font-size: 15px; text-align: start; background-color: rgb(255, 255, 255); display: inline !important; box-sizing: border-box;">--</span><br style="font-family: "Segoe UI", "Segoe UI Web (West European)", "Segoe UI", -apple-system, BlinkMacSystemFont, Roboto, "Helvetica Neue", sans-serif; font-size: 15px; text-align: start; background-color: rgb(255, 255, 255); box-sizing: border-box;" fr-original-style="font-family: "Segoe UI", "Segoe UI Web (West European)", "Segoe UI", -apple-system, BlinkMacSystemFont, Roboto, "Helvetica Neue", sans-serif; font-size: 15px; text-align: start; background-color: rgb(255, 255, 255);"><div dir="ltr" fr-original-style="font-size: 15px; font-family: "Segoe UI", "Segoe UI Web (West European)", "Segoe UI", -apple-system, BlinkMacSystemFont, Roboto, "Helvetica Neue", sans-serif; margin: 0px; text-align: start; background-color: rgb(255, 255, 255);" style="font-size: 15px; font-family: "Segoe UI", "Segoe UI Web (West European)", "Segoe UI", -apple-system, BlinkMacSystemFont, Roboto, "Helvetica Neue", sans-serif; margin: 0px; text-align: start; background-color: rgb(255, 255, 255); box-sizing: border-box;"><div dir="ltr" fr-original-style="margin:0px;" style="margin: 0px; box-sizing: border-box;">Chris Hughes<div fr-original-style="font-size:12.79px;margin:0px;" style="font-size: 12.79px; margin: 0px; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="font-size:12.79px;margin:0px;" style="font-size: 12.79px; margin: 0px; box-sizing: border-box;">GIS Analyst</div><div fr-original-style="font-size:12.79px;margin:0px;" style="font-size: 12.79px; margin: 0px; box-sizing: border-box;">Lincoln County GIS Department </div><div fr-original-style="margin:0px;" style="margin: 0px; box-sizing: border-box;"><span fr-original-style="font-family:Roboto, arial, sans-serif;margin:0px;" style="font-family: Roboto, arial, sans-serif; margin: 0px; box-sizing: border-box;">880 NE 7th S</span><span fr-original-style="font-family:Roboto, arial, sans-serif;margin:0px;" style="font-family: Roboto, arial, sans-serif; margin: 0px; box-sizing: border-box;">t</span>. l Newport, OR 97365</div><div fr-original-style="font-size:12.79px;margin:0px;" style="font-size: 12.79px; margin: 0px; box-sizing: border-box;">Tel: (541) 574 1283</div></div></div><br fr-original-style="" style="box-sizing: border-box;"></div></div></div></div><div fr-original-style="" id="appendonsend" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><hr style="display: inline-block; width: 98%; box-sizing: border-box; clear: both; user-select: none; break-after: page;" tabindex="-1" fr-original-style="display:inline-block;width:98%;"><div dir="ltr" fr-original-style="" id="divRplyFwdMsg" style="box-sizing: border-box;"><strong fr-original-style="" style="box-sizing: border-box; font-weight: 700;">From:</strong> GeoMoose-users <geomoose-users-bounces@lists.osgeo.org> on behalf of Brent Fraser <bfraser@geoanalytic.com><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="box-sizing: border-box; font-weight: 700;">Sent:</strong> Friday, January 6, 2023 8:32 AM<br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="box-sizing: border-box; font-weight: 700;">To:</strong> GeoMoose Users <geomoose-users@lists.osgeo.org><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="box-sizing: border-box; font-weight: 700;">Subject:</strong>Re: [GeoMoose-users] One to Many Join - GeoMoose 3<div fr-original-style="" style="box-sizing: border-box;"> </div></div><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="font-family:arial; font-size:14px;" style="font-family: arial; font-size: 14px; box-sizing: border-box;"><div fr-original-style="box-sizing:border-box;" id="x_isPasted" style="box-sizing:border-box;">Chris,</div><div fr-original-style="box-sizing:border-box;" style="box-sizing:border-box;"><br style="box-sizing:border-box;" fr-original-style="box-sizing:border-box;"></div><div fr-original-style="box-sizing:border-box;" style="box-sizing:border-box;">It's an interesting problem.  Depending on how you want the user access and visualize the data, where could be other solutions.  One solution would be to would be to write a server-side script (in Python, PHP, etc) to take an ID parameter and return an HTML page of records of the join table.  You could put a link in each of  the GeoMoose result rows to reference the script, something like</div><div fr-original-style="box-sizing:border-box;" style="box-sizing:border-box;"><br style="box-sizing:border-box;" fr-original-style="box-sizing:border-box;"></div><div fr-original-style="box-sizing:border-box;" style="box-sizing:border-box;">  <a fr-original-style="box-sizing:border-box; color:rgb(0,102,147); text-decoration:underline;" href="https://myserver/getBuildings.php?parcel_id=2102" rel="noopener noreferrer" style="box-sizing: border-box; color: rgb(0, 102, 147); text-decoration: underline; user-select: auto;" target="_blank" rel="noopener noreferrer"> https://myserver/getBuildings.php?parcel_id=2102</a></div><div fr-original-style="box-sizing:border-box;" style="box-sizing:border-box;">  <a fr-original-style="box-sizing:border-box; color:rgb(0,102,147); text-decoration:underline;" href="https://myserver/getBuildings.php?parcel_id=2102" rel="noopener noreferrer" style="box-sizing: border-box; color: rgb(0, 102, 147); text-decoration: underline; user-select: auto;" target="_blank" rel="noopener noreferrer"> https://myserver/getBuildings.php?parcel_id=</a>4037</div><div fr-original-style="box-sizing:border-box;" style="box-sizing:border-box;"><br style="box-sizing:border-box;" fr-original-style="box-sizing:border-box;"></div><div fr-original-style="box-sizing:border-box;" style="box-sizing:border-box;">Clicking on one of these would bring a list of "joined" records in a new page or popup.</div><div fr-original-style="box-sizing:border-box;" style="box-sizing:border-box;"><br style="box-sizing:border-box;" fr-original-style="box-sizing:border-box;"></div><div fr-original-style="box-sizing:border-box;" style="box-sizing:border-box;">Brent</div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" id="x_Signature" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div></div></div><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div></div></div></div></div></div>