Join Properties — Primary key from source table, foreign key from destination table

208
0
2 weeks ago
Status: Open
Labels (1)
Bud
by
Notable Contributor

ArcGIS Pro 3.3.0; File Geodatabase.

I have two standalone tables called TABLE_A to TABLE_B. I join from the TABLE_A to TABLE_B using ID fields, creating a 1:M join .

In the Catalog layer properties > Joins tab of TABLE_A, the join is displayed as:

  • Primary key: B_ID
  • Foreign key: A_ID

Bud_0-1715909067434.png

Maybe I'm missing something, but that seems backwards. To me, the input table's field A_ID should be the primary key. And the join table's field B_ID should be the foreign key.

Like this:

Bud_1-1715909427043.png

Video:

Could that be changed so that the primary and foreign keys are more intuitive? Like I said, let me know if I've misunderstood something.