ArcGIS for Desktop

  • Documentation
  • Pricing
  • Support

  • My Profile
  • Help
  • Sign Out
ArcGIS for Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS for Desktop

A complete professional GIS

ArcGIS for Server

GIS in your enterprise

ArcGIS for Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Pricing
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

Help

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • More...

24040: Layer has an in-memory join or relate

  • Solution
  • More information

Your map layer has an associated join or relate that was created in the map document using the layer properties dialog box. Joined and related attributes will not be accessible through the feature service.

Solution

If your layer has a join:

  • Create a view. A view is a stored query that selects data from specified tables.

    Learn more about views and creating a database view in ArcGIS for Desktop

  • Or, you could export your layer with the join to a new feature class and use this new feature class in the map you want to publish.
    1. Right-click the layer in the table of contents.
    2. Click Data > Export Data.
  • You can remove the joins from your layer.
    1. Open the Layer Properties dialog box.
    2. Click the Joins & Relates tab.
    3. Click Remove.
  • Do nothing. The joined attributes will not be available through the feature service.

If your layer has a relate:

  • Make sure both the table and the layer involved in the relationship class are in the data frame.
  • You can remove the relate from your layer.
    1. Open the Layer Properties dialog box.
    2. Click the Joins & Relates tab.
    3. Click Remove.
  • Do nothing. The related attributes will not be available through the feature service.

More information

Feature services allow queries on related data. For example, a published map document can have layers and tables that are related through geodatabase relationship classes. In this case, the feature service allows queries on a layer to return objects from the related layer or table. Note that to support queries that return related objects, both the table and the layer involved in the relationship class must be in the published map document. If either the origin and/or destination layer or table is not included in the map document, the relationship is ignored by the feature service.

Learn more about joining and relating tables

Learn more about authoring feature services

Feedback on this topic?

ArcGIS for Desktop

  • Home
  • Documentation
  • Pricing
  • Support

ArcGIS Platform

  • ArcGIS Online
  • ArcGIS for Desktop
  • ArcGIS for Server
  • ArcGIS for Developers
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Insiders Blog
  • User Conference
  • Developer Summit
Esri
© Copyright 2016 Environmental Systems Research Institute, Inc. | Privacy | Legal