Join working in one direction but not the other

[BrianCohenTNC]

Hi

I'm attempting to join a standalone table to a point feature class table. Both are in the same geodatabase, and the join field in the standalone table is the result of a buffer function on the point file and is a text field as is the point table join field. When I attempt to join the standalone table to the point table, it only joins a fraction of the records (16 o 136). When I reverse it and join the point table to the standalone table it executes successfully and all 136 records are joined. The point table has more records than the standalone table as I only performed the buffer on a subset of the points.

ArcGIS Pro 3.0.1, Windows 10, Intel(R) Core(TM) i9-10885H CPU @ 2.40GHz 2.40 GHz, RAM 32.0 GB

[DanPatterson]

Is there a chance there is a many-to-one relationship?  ( Add Relate (Data Management)—ArcGIS Pro | Documentation )

which Validate Join doesn't check for

[BrianCohenTNC · Accepted solution]

Thanks Dan. It is a one-to-one relationship. I have recreated the standalone table and the join now works. Similar solution to the old "turn it off and back on" approach. Thanks for your reply.