It sounds like you have an outer join specified for your join rather than an inner join. In Studio 2009, you have the option of selecting an outer or inner join. If you're not using Studio 2009, I'm not sure what options you have, but you can edit the XML and upload the datasource via the mapagent. The XML element <RelateType> should be set to Inner.
Andy Morsell, P.E. Spatial Integrators, Inc. www.SpatialGIS.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Crispin_at_1Spatial Sent: Monday, August 25, 2008 5:56 AM To: [email protected] Subject: [mapguide-users] Feature Joins - How? Hi, Trying to understand feature joins so I tried some tests and failed miserably... can anyone expand on the logic below: 1) I created a new featuresource and layer (SDF data), turned the FeatId on as the tooltip and previewed the data, noted down a FeatId that I could readily identify (e.g. 123) 2) I created an Access DB with a new table and a column (Numeric, Long) called ID_NumLong and made it a primary key, then added one value to the table as noted above (e.g. 123) 3) I added an ODBC system DSN to the MDB and in MapGuide a new ODBC feature source connection. 4) I edited my original layer, linked the new ODBC featuresource as a join and selected FeatId->ID_NumLong as an Inner join 5) Previewed the layer expecting to see only the linked feature displayed ... but the complete dataset displayed as before. Not happy. -- View this message in context: http://n2.nabble.com/Feature-Joins---How--tp781352p781352.html Sent from the MapGuide Users mailing list archive at Nabble.com. _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
