I agreed with Martin Morrison. I will join two tables with PostgreSQL as one spatial view table.
If you would like to enable the selection for spatial view, you may check out following link: http://osgeo-org.1560.x6.nabble.com/SQL-Server-Spatial-View-Selection-Issue-td5228068.html However, if you really dislike the large joint table... I will develop a PHP, and ASP .NET etc. web page to query and display the *State Power Load* table info based on the *State ID*. Display the PHP/ASP .NET web page by map tip hyper link, opening the new window, or task panel (Fusion). Cheers! -- Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html _______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users