Skip To Content

24040: Layer has an in-memory join or relate

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 are not accessible through the feature service.


You do not have to remove the in-memory join or related attributes, but you won't be able to access the joined or related data from the feature service.

If you want access to joined data, do one of the following:

  • Create a view. A view is a stored query that selects data from specified tables.
  • 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.

If you want access to related data and your source data is in a geodatabase, create a relationship class instead of relating data in the map document.

If you do not need the related or joined data, and you don't want this warning to be returned when analyzing, you can remove the join or relate from your layer:

  1. Open the Layer Properties dialog box.
  2. Click the Joins & Relates tab.
  3. Click Remove.

More information

Feature services allow queries on related data only if you use a relationship class. 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 you don't include either the origin and/or destination layer or table in the map document, the feature service ignores the relationship.

Learn more about joining and relating tables

Learn more about authoring feature services

In this topic
  1. Solution
  2. More information