AnsweredAssumed Answered

use multiple fileds as primary/foreign key

Question asked by paopen69 on Jan 22, 2016
Latest reply on Jan 26, 2016 by wwmiller68

Hi everybody,

I'm guessing if in ArcGIS it is possible to use the join or create a relationship class commands using multiple fields as primary/foreign keys.

I mean...I've got field A, B and C. Separatley they are not a primary key, but if I concatenate A+B+C they become a primary key.

What I've done since today is creating an extra field that I populate with a concatenation expression using the field calculator. This is an annoying solution since I've to create a redundant field in both the primary/foreign tables (I often can't do that because of the feature class schema) and I've to "maintain" that redundant fields (executing the field calculator's concatenation expression each time there are some changings).

I can't believe there's not another more pratical solution...
I will appreciate any and every suggestion!
Thanks in advance,