Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I am trying to make a relationship class between two tables, but I get this message at the end: " Failed to create the specified relationship class". Can you tell me why?

Thanks, Ligia

Sorry I wasn't more precise:- I use ArcEditor licence level, ArcGIS 10.0 version, and we're talking about a file geodatabase. I have a table for "ducts" and a table for "cables". A "duct feature" may have several "cable features", the forein key is the ID of the ducts. It's a one-to-many simple relationship.

share|improve this question
3  
I'm afraid this question is along the lines of "my car won't start, can you tell me why?". More information is needed otherwise no one will answer for fear of absolutely wasting their time –  Stev_k Apr 2 '12 at 15:56
    
How about starting with the basics: arcgis license level (AV, AE, AI); arcgis version #; geodatabase type (SDE, fgdb, pgdb)? –  RyanDalton Apr 2 '12 at 16:10
    
Sorry I wasn't more precise:- I use ArcEditor licence level, ArcGIS 10.0 version, and we're talking about a file geodatabase. I have a table for "ducts" and a table for "cables". A "duct feature" may have several "cable features", the forein key is the ID of the ducts. It's a one-to-many simple relationship. –  Ligia Apr 3 '12 at 7:26
add comment

1 Answer

Table to table relationship classes are not supported in ArcGIS 10.0! I was trying to do the exact same thing and an ESRI rep filled me in that it simply isn't possible. Only feature class to table relationships are supported (at version 10.0).

share|improve this answer
    
Surprisingly,after several attempts I was able to create a table to table relationship class in arcgis.10, but this time it was a composite one to many relationship not a simple one. so probably this was "the thing ", I don't know. –  Ligia Apr 17 '12 at 12:52
    
I've done a Many-to-Many relationship, which uses a 'junction table' that links keys from tables on either end, but it only works in one direction. It seems like table-to-table may be possible, but you should expect some 'Weird' things to happen as a result. –  Roy Apr 20 '12 at 12:32
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.