<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16441" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=109522315-11052007><FONT face=Arial size=2>Hi MapServer
Users,</FONT></SPAN></DIV>
<DIV><SPAN class=109522315-11052007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=109522315-11052007><FONT face=Arial size=2>I thought I would
give this one more try. I'm curious to hear if anyone has one-to-many
joins working with a .dbf in MapServer 4.10.1? I can't seem to get it to
work, unless I just have the join and query templates defined incorrectly.
See below. Thanks for any help.</FONT></SPAN></DIV>
<DIV><SPAN class=109522315-11052007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=109522315-11052007><FONT face=Arial size=2>
<DIV><SPAN class=985165521-08052007><FONT face=Arial size=2>LAYER # Dummy
Parcels Polygon Layer to Highlight it yellow<BR> NAME
parcel_query<BR> DATA parcels<BR> MAXSCALE
50000<BR> MINSCALE 500<BR> STATUS
DEFAULT</FONT></SPAN></DIV>
<DIV><SPAN class=985165521-08052007><FONT face=Arial size=2>
HEADER 'header.html' <BR> FOOTER
'footer.html' <BR>
JOIN<BR> FROM
"PIN"<BR> NAME
"MULTI"<BR> TABLE
"E:\mapdata\douglas_mn\LUT_MULTI_INTEREST.DBF"<BR>
TEMPLATE
"multi_parcel_selected.html"<BR> TO
"MI_PIN"<BR> TYPE
ONE-TO-MANY<BR> END<BR> TYPE
POLYGON<BR> CLASSITEM 'CODE'<BR>
CLASS<BR> NAME "Parcel
Selected"<BR> EXPRESSION
"1"<BR> TEMPLATE
"parcel_selected.html"<BR> SYMBOL
'plainline'<BR> COLOR -1 -1
-1<BR> OUTLINECOLOR 255 255
0<BR> SIZE 4<BR>
END<BR>
CLASS<BR> NAME
"Multi-Interest
Parcel"<BR> EXPRESSION
"3"<BR> TEMPLATE
"multi_parcel_selected.html"<BR>
SYMBOL 'plainline'<BR>
COLOR -1 -1 -1<BR>
OUTLINECOLOR 255 255 0<BR>
SIZE 4<BR> END<BR> END</FONT></SPAN></DIV>
<DIV><SPAN class=985165521-08052007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=985165521-08052007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=985165521-08052007><FONT face=Arial size=2>HTML Query
Template:</FONT></SPAN></DIV>
<DIV><SPAN class=985165521-08052007><FONT face=Arial size=2><tr><BR><td
colspan="2">This is a multi interest
property.</td><BR></tr><BR><tr><BR><td>PIN:</td><BR><td><a
href='javascript:openwin("parceldetail","../parcelform.php?pin=[MULTI_PIN]")'>[MULTI_PIN]</a></td><BR></tr><BR><td
colspan="2"><hr></td></FONT></SPAN></DIV></FONT></SPAN></DIV>
<DIV> </DIV>
<DIV align=left><SPAN lang=en-us><B><FONT face=Arial>Brian
Fischer,</FONT></B></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us> <FONT
face=Arial size=2>C</FONT><FONT face=Arial><FONT
size=2>FM</FONT></FONT></SPAN></DIV>
<DIV align=left><SPAN lang=en-us><FONT face=Arial><FONT size=2>GIS Project
Manager<BR></FONT><B><I><FONT color=#005b45>Houston Engineering,
Inc.</FONT></I></B> <FONT size=2>|</FONT></FONT> <FONT face=Arial color=#005b45
size=2>Leave Nothing to Chance</FONT><SUP><FONT face=Arial color=#005b45
size=2>TM<BR></FONT></SUP><FONT face=Arial size=2>6901 East Fish Lake
Road</FONT></SPAN><SPAN lang=en-us><FONT face=Arial size=2>, Suite 140<BR>Maple
Grove, MN 55369<BR>Phone: 763.493.4522 / Fax:
763.493.5572<BR>Email: </FONT></SPAN><SPAN lang=en-us> </SPAN><A
href="mailto:bfischer@houstonengineeringinc.com"><SPAN lang=en-us></SPAN><SPAN
lang=en-us><U><FONT face=Arial color=#0000ff
size=2>bfischer@houstonengineeringinc.com</FONT></U></SPAN><SPAN
lang=en-us></SPAN></A><SPAN lang=en-us></SPAN><SPAN lang=en-us><BR><FONT
face=Arial size=2>Website:</FONT></SPAN><SPAN lang=en-us> </SPAN><A
href="http://www.houstonengineeringinc.com/"><SPAN lang=en-us></SPAN><SPAN
lang=en-us><U><FONT face=Arial color=#0000ff
size=2>www.houstonengineeringinc.com</FONT></U></SPAN><SPAN
lang=en-us></SPAN></A><SPAN lang=en-us></SPAN><SPAN lang=en-us></SPAN> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV></BODY></HTML>