There is a "One to many" / "Many to many" property on the FeatureSource.

But as I understand it, joins are meant to supplement a feature with additional attributes. If my understanding holds, you can never have multiple rows attached to a single feature,
and I am pretty sure that the viewer won't show it.

If you obtain the join key, you can select the rows from the database, and display them. That will be much easier than trying to get the viewer to display these extra rows.

Regards, Kenneth Skovhede, GEOGRAF A/S



Steve G skrev:
I am using MG 2.0.  Using MapGuide Studio 2009 I've made a data connection
using the ODBC connection FDO (Connect via a DNS, connected to SQL Server
database).  The connection works (I am having some performance issues, but
that belongs in another post).  Next, I've joined this data using a
one-to-many join with a SHP file (table from the shp file is the primary and
data in the database is secondary).  The join seems to work ok.  However,
when I use the standard Select tool, the properties pane will only show one
of the records in the database, I believe the first entry.  I want to
display all of the records in the joined table.

Does anyone know how I can display multiple records in the properties pane? I am using the standard ajax viewer. Perhaps there is something to change
in the "ajaxmappane.templ" file?  I've possibly found some code around line
2582 that perhaps can be manipulated?  Sorry, I am not much of a programmer,
so any assistance would be greatly appreciated.

Thanks,

Steve
_______________________________________________
mapguide-users mailing list
mapguide-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users

Reply via email to