<div style="font-family: arial; font-size: 14px;"><div fr-original-style="box-sizing: border-box;" id="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; user-select: auto;" 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; user-select: auto;" 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=""><br fr-original-style=""></div><div fr-original-style="" contenteditable="false"><span fr-original-style="" style="box-sizing: border-box;"> </span></div><div fr-original-style=""><br fr-original-style=""></div><hr id="previousmessagehr" fr-original-style="" style="box-sizing: border-box; clear: both; user-select: none;"><div fr-original-style=""><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=""><strong fr-original-style="" style="box-sizing: border-box; font-weight: 700;">Sent</strong>: 1/6/23 9:15 AM<br fr-original-style=""><strong fr-original-style="" style="box-sizing: border-box; font-weight: 700;">To</strong>: James Klassen <klassen.js@gmail.com>, "bfraser@geoanalytic.com" <bfraser@geoanalytic.com><br fr-original-style=""><strong fr-original-style="" style="box-sizing: border-box; font-weight: 700;">Cc</strong>: geomoose-users-osgeo <geomoose-users@lists.osgeo.org><br fr-original-style=""><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=""><br fr-original-style=""></div><div fr-original-class="elementToProof" fr-original-style=""><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;">The main reason I was looking at the mapserver join was because there were pretty good examples of how to return html results for a one-to-many join. Checked apache logs, auto identify results, and DEBUG 5 and didn't get anything that would indicate the joined table was being included.</span></div><div fr-original-class="elementToProof" fr-original-style=""><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=""></span></div><div fr-original-class="elementToProof" fr-original-style=""><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;">Just wanted to make sure there wasn't something I was missing, like config options in the mapbook.</span></div><div fr-original-class="elementToProof" fr-original-style=""><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=""></span></div><div fr-original-class="elementToProof" fr-original-style=""><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!</span></div><div fr-original-class="elementToProof" fr-original-style=""><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=""></span></div><div fr-original-class="elementToProof" fr-original-style=""><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);"><br fr-original-style=""></div><div fr-original-style="" id="Signature"><div fr-original-style=""><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);"><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);" 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);"><div dir="ltr" fr-original-style="margin:0px;" style="margin:0px;">Chris Hughes<div fr-original-style="font-size:12.79px;margin:0px;" style="font-size:12.79px;margin:0px;"><br fr-original-style=""></div><div fr-original-style="font-size:12.79px;margin:0px;" style="font-size:12.79px;margin:0px;">GIS Analyst</div><div fr-original-style="font-size:12.79px;margin:0px;" style="font-size:12.79px;margin:0px;">Lincoln County GIS Department </div><div fr-original-style="margin:0px;" style="margin:0px;"><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;">Tel: (541) 574 1283</div></div></div><a fr-original-style="" href="https://lists.osgeo.org/mailman/listinfo/geomoose-users" rel="noreferrer" style="box-sizing: border-box; color: rgb(0, 102, 147); text-decoration: underline; user-select: auto;" target="_blank" rel="noopener noreferrer">https://lists.osgeo.org/mailman/listinfo/geomoose-users</a></div></div></div></div><div fr-original-style=""><div fr-original-style=""><div fr-original-class="x_gmail_quote" fr-original-style=""><br fr-original-style=""></div></div></div></div>