[mapguide-users] Show Multiple Properties for selection

[Kenneth Skovhede, GEOGRAF A/S]

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
>