join with dbf file

[Fischer, Brian]

I am trying to do a one-to-many join to a .dbf file and am not getting
the results I want.  I was wondering if anyone has had a similar
problem.  I keep getting back one record with the my join table field
not being replaced.  If I remove the template from the class object I
don't get any features returned.  Do I have the join defined
incorrectly?  Here is what my layer definition looks like and my HTML
template.
 
LAYER # Dummy Parcels Polygon Layer to Highlight it yellow
    NAME parcel_query
    DATA parcels
    MAXSCALE 50000
    MINSCALE 500
    STATUS DEFAULT
    HEADER 'header.html' 
    FOOTER 'footer.html' 
    JOIN
        FROM "PIN"
        NAME "MULTI"
        TABLE "E:\mapdata\douglas_mn\LUT_MULTI_INTEREST.DBF"
        TEMPLATE "multi_parcel_selected.html"
        TO "MI_PIN"
        TYPE ONE-TO-MANY
    END
    TYPE POLYGON
    CLASSITEM 'CODE'
    CLASS
        NAME "Parcel Selected"
        EXPRESSION "1"
        TEMPLATE "parcel_selected.html"
        SYMBOL 'plainline'
        COLOR -1 -1 -1
        OUTLINECOLOR 255 255 0
        SIZE 4
    END
    CLASS
          NAME "Multi-Interest Parcel"
          EXPRESSION "3"
          TEMPLATE "multi_parcel_selected.html"
          SYMBOL 'plainline'
          COLOR -1 -1 -1
          OUTLINECOLOR 255 255 0
          SIZE 4
    END
  END
 
 
HTML Query Template:
<tr>
<td colspan="2">This is a multi interest property.</td>
</tr>
<tr>
<td>PIN:</td>
<td><a
href='javascript:openwin("parceldetail","../parcelform.php?pin=[MULTI_PI
N]")'>[MULTI_PIN]</a></td>
</tr>
<td colspan="2"><hr></td>
 
Thanks,
Brian
 
Brian Fischer, CFM
GIS Project Manager
Houston Engineering, Inc. | Leave Nothing to ChanceTM
6901 East Fish Lake Road, Suite 140
Maple Grove, MN 55369
Phone:  763.493.4522 / Fax:  763.493.5572
Email:  bfischer at houstonengineeringinc.com
<mailto:bfischer at houstonengineeringinc.com> 
Website: www.houstonengineeringinc.com
<http://www.houstonengineeringinc.com/>  
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20070508/11f092a9/attachment.htm>