Chris, MGOS 1.2 did have some join issues and I believe you might be encountering one of them. Are you doing an inner or outer join? With MGOS 2.0 I have joined SDFs with Access many times in the following cases:
Inner 1-1 Inner 1-Many Outer 1-1 Outer 1-Many The above worked for my use cases with MGOS 2.0. Would you be able to try MGOS 2.0? Thanks, Bruce From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Tallman Sent: Monday, March 10, 2008 7:28 AM To: MapGuide Users Mail List Subject: [mapguide-users] Feature Joins Morning all. Is anyone seeing issues with joins, using one-to-many? I have an sdf feature joined to a MSAccess file. I'm only seeing the first join per feature, the second, third and on are ignored. I'm on MGOS 1.2 IIS 6 .net install. I've created the same join in autocad and I don't have a problem. More detail: I have a sdf feature source that is buildings. My database has a list of majors. Both have a Building ID. One id per building. Multiple majors per building. I'm trying to create layers based on the join that displays buildings based on majors. If a building has multiple majors it only shows up once and it seems to only be the first match it comes across. So I guess it's acting more like a one-to-one join. I hope this enough explanation someone will be able to help me out. If not let me know and I can try and explain more. Chris Tallman Director of GIS Operations Innovation Mapping, LLC 260-356-9074
_______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
