New for ArcGIS 10, you can analyze a join before creating it by using the Validate Join button on the Join Data dialog box. Join validation allows you to assess any potential problems that you might encounter when creating a join. Join validation analyzes the two participating datasets to determine if there are any common problems with the data. The following is a list of what is checked in the data:
- Check for field names that start with an invalid character.
- Check for field names that contain an invalid character.
- Check for field names that match reserved words.
- Check for non-geodatabase MS Access tables