English

Bug: Cannot calculate fields when tables or feature classes are joined

Description



** This issue is addressed in ArcGIS 9.0 Service Pack 2 (SP2).

Click on the link in Related Information below and download Service Pack 2, if necessary. **



If two tables are joined, Table B is joined to an origin Table A, there are issues if attempting to use the geoprocessing Calculate Field tool. In ArcCatalog, the geoprocessing scripting environment and Model Builder, it is not possible to calculate any field after two tables have been joined. In ArcMap, users are able to calculate fields in the origin table (Table A) but not the join table (Table B).

Cause



This is a known issue.



This functionality was not supported at the release of 9.0, however, it IS supported with the release of SP2.

Workaround

** This issue is addressed in ArcGIS 9.0 Service Pack 2 (SP2).

Click on the link in Related Information below and download Service Pack 2, if necessary. **



If the Service Pack 2 is unavailable, follow the workaround below. If information in a field in a separate table is needed to perform a calculation, then the operation must be carried out in ArcMap. Only fields in the origin table or feature class can be calculated, so create the joins appropriately.

  1. Right-click the table or feature class that contains the field that to calculate. Select Joins and Relates > Join. This calls the Join Data window. Fill in the input field on this window as appropriate.
  2. Right-click the table with the field to be calculated and click 'Open' after joining the tables. Find the field, right-click on it and select Calculate Field. A window appears warning that it is calculating outside the edit environment and asks to continue. Click Yes. This calls the Field Calculator.
  3. In the Field Calculator, select the field and build the expression as appropriate. Click OK.