This functionality is more dependent upon your web mapping application or the API you may be using. I am not sure how to do this with GeoCortex. If your database relationships are set up properly, I think the next place to focus is on how to expose those relationships based on the application itself. One thing to try might be building a Query Layer in the map document before publishing the service. The query layer would need to be a join between your spatial data and your non-spatial data. Otherwise, you can build a spatial view at the RDBMS level using the SDETABLE command (and edit the view's SQL via your RDBMS tools later if you wish). In either case, those would become layers in your map document. However, since you mentioned a 1-to-many relationship then I am not sure how much this would benefit you.
I don't think tables published via an ArcGIS map service will appear in the TOC of a web application. To consume the table information, I think you would need to perform an action such as an identify if the table was related or joined to a feature class. Tables are not layers so they aren't really visible to the application per se. In other words, just because you can publish it in a map service does not mean that it is consumable in the same way that a map layer would be. That being said, you may be able to add the table to your map document as an XY event layer if it has X and Y columns in order to publish it and view its spatial contents within the web application.
Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
