Have you tried creating a view/query in the ODBC database itself and mapping it? I understand version 1.2.0 will read views.
Keith -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of uXuf Sent: 20 November 2007 01:19 To: [email protected] Subject: [mapguide-users] Building an intelligent tooltip Hi guys, I am trying to build a tooltip that contains data from multiple tables (essentially - a join). I have a point layer that gets populated from an ODBC source. The table has a relatively simple structure: PointID, PointName, PointLat, PointLon and PointTypeID. Now this PointType is a foreign key into a Types table which contains only the TypeID and TypeName fields. What I'd like is the tooltip to resolve the PointTypeID and get the TypeName to display. I tried feature-joining the ODBC Source with itself (figures since both the tables are in the same db), and created a new Extended class (named PlaceType). This extended class has its primary feature class as the Points table (or Default:points) and the secondary feature class as the Types table (Default:types). I then specified for join the PointTypeID column and the TypeID column. Now when I reselect the feature source (in an effort to update the Feature Class dropdown list) I DO get the Default:PlaceType class, but if I select it I lose all my geometry fields. This extended class apparently does not pick up the Lat and Lon columns from the original tables, it only picks up the PointID and PointName columns. So basically in an effort to get a join I lose my geometry fields. Any insights into this or would I have to add *yet* another layer with only tooltips and no points? Probably a better solution would be to allow SQL type expressions in the expression builder, a bit reminiscent of MG 6.x. Regards, uXuf -- View this message in context: http://www.nabble.com/Building-an-intelligent-tooltip-tf4840591s16610.ht ml#a13849076 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 This message has been scanned for viruses by MailControl - (see http://bluepages.wsatkins.co.uk/?6875772) This email and any attached files are confidential and copyright protected. If you are not the addressee, any dissemination of this communication is strictly prohibited. Unless otherwise expressly agreed in writing, nothing stated in this communication shall be legally binding. The ultimate parent company of the Atkins Group is WS Atkins plc. Registered in England No. 1885586. Registered Office Woodcote Grove, Ashley Road, Epsom, Surrey KT18 5BW. Consider the environment. Please don't print this e-mail unless you really need to. _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
