[mapguide-users] MGOS v2.0 join with other feature source issue

[David Nuell]

Hi Jackie - 

I have tried it both ways.

Attempt 1: In the original polygon layer (parcels), there is an attribute
labelled ObjectID.  I attached a table called 'Parcel Information' where

parcels.ObjectID=ParcelInformation.ParcelOID

That join works ok and can be displayed.  When I try to connect a second
table 'DeveloperAgreements' to the already joined attribute where

ParcelInformation.ParcelUniqueID=DeveloperAgreements.ParcelUniqueID_FK

It fails to draw the layer.  The join can be seen, but no polygons are
shown.

Attempt 2:

I added the attribute 'ParcelUniqueID' to my polygon layer and re-loaded the
SHP to MG Studio.  I then attempt to join

Parcels.objectID=ParcelInformation.ParcelOID

This works fine as in the first attempt.  When I attempt to connect the
second table with the new ParcelUniqueID in the parcels polygon layer such
as

Parcels.ParcelUniqueID=DeveloperAgreements.ParcelUniqueID_FK

The join works ok, however no polygons are drawn.

Hope the information above can help someone help me out... thanks for the
reply jackie.





Jackie C. Ng wrote:
> 
> With the second table, are you trying to join with the primary (one with
> polygons) or the secondary (the access database) feature class?
> 
> - Jackie
> 
> 
> David Nuell wrote:
>> 
>> Hi all -
>> 
>> I have MGOS v2.0 installed on a Win box with server 2003 installed.  I am
>> also using Autodesk MapGuide Studio v 1.2.0.410 to build the web page.
>> 
>> I have connected my MS Access DB through OSGeo FDO Provider for ODBC and
>> am attempting to join the tables within that DB with my data layer.
>> 
>> I am successful in connecting a single table to my data and it displays
>> perfectly fine with the joined attributes.  When I attempt to connect a
>> second table to the same data, the join works perfectly fine, however the
>> data (polygons) do not display anymore.  When I remove the second table
>> and refresh, it displays just fine again.
>> 
>> I have tried different tables, and in different orders however it seems
>> that only a single table can be joined and be displayed.  Has anyone else
>> run into this?  Is there a maximum number of joins allowed?
>> 
>> cheers.
>> 
>> 
> 
> 

-- 
View this message in context: http://www.nabble.com/MGOS-v2.0-join-with-other-feature-source-issue-tp16834759p16895767.html
Sent from the MapGuide Users mailing list archive at Nabble.com.