Populate A Related Table

11-05-2013 11:45 AM
New Contributor
I've got a feature class with a relationship class build to another table.  The only method I can find to populate this related table is:
4.Interactively select related origin and destination objects using the Edit tool. If a table is participating in the relationship, open the table and select the desired rows.
5.Open the Attribute dialog box by clicking the Attributes button on the Editor toolbar. The selected features will appear in the left panel of the Attribute dialog box.
6.Expand one of the selected feature classes in the left panel and right-click the relationship class label.
7.Click the Add Selected option. This will add a row to the intermediate table and populate the foreign key fields with the related primary key values.
8.Repeat steps 4 through 7 to populate the relationship class table with all the appropriate relationships between objects.
(from http://resources.arcgis.com/en/help/main/10.1/index.html#//004t0000000m0000003)

I'd like to add all records at once rather than one at a time.  How can I accomplish this?
Relationship Class Properties:
Type: Composite
Cardinality: 1-M
Notification: Forward
Primary Key: ID *this is not ObjectID
Foreign Key: ID *this is not ObjectID
0 Kudos
1 Reply
MVP Regular Contributor
Since your table is already populated, I would recommend considering the Table to Relationship Class tool (http://resources.arcgis.com/en/help/main/10.1/index.html#//0017000000mp000000) to achieve what you are describing.  The tool itself should allow you to do what you are hoping to do without so much manual labor.  It's also possible that the tool could be better served in a custom Python script depending on your specific needs.
0 Kudos