How to make a relationship (one to many) using shp file and a table

[Muhammad_SherazAhsan]

I have a shp file and a table.

I need to join them through common OBJECT ID..
In shp file there is single entry for the OBJECT ID,,but there are multiple entries for the same OBJECT ID in the table...When join one record of the table is joined to the shp file...

What we want is to make a relation of  all the information of table to the shp file..

[JeffWard]

You want to do a relate instead of a join.  You can right click on the shp file in the table of contents and select Joins and Relates - Relate.  In the relate dialog you can specify the field that is common to both the shapefile and the table.

Or you could import the shapefile to a file geodatabase feature class and set up a relationship class that would be more permanent.  The relate in a map document is only available in that map document, where a relationship class would be available any time you added the feature class to a new map document.

Hope that helps,

Jeff Ward
Summit County GIS

[stuartcassin]

I've been trying to establish a relate between a shp file and a table today and the process appears to be successful but when I select a feature and then the related table from the options menu, the related table is greyed out and unavaialble.

I have no idea why the related data won't show up as i know for a fact that it's in the table (it's confirmed data) and can't think of any reason why it wouldn't work.

Any ideas would be greatfully accepted.

[DavidBridle]

Hi,

Have you checked that the table has an ObjectID field and that the ObjectID field has the data type ObjectID (rather than double)? This is a precondition for relates. If not you can add one by importing to a geodatabase. Now the relate should no longer be grayed out. Hope this works.

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//005s0000000z000000.htm