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

Bud — Tue, 21 May 2024 10:10:27 GMT

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

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:

Video:

(view in My Videos)

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.

idea Join Properties — Primary key from source table, foreign key from destination table in ArcGIS Pro Ideas

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