BUG

Only matching records are preserved when creating a Join through the Layer Properties > Joins and Relates tab

Last Published: April 25, 2020

Description

**This issue appears with ArcGIS 9.l, Service Pack 2**If a Join is established in the Layer Properties > Joins and Relates tab, only matching records are preserved. This occurs even if the default of 'Keep All Records' is selected.

Cause

This is a known limitation.

Workaround

Establish the join through the layer context menu, or with the Add Join tool from ArcToolbox.

    Article ID:000008900

    Software:
    • ArcMap 9 x

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options

    Discover more on this topic

    Esri Community

    Search for related information

    Training

    Find training related to this topic

    ArcGIS Ideas

    Explore ideas and give feedback