Join fails after indexing table

Question

While in arcmap joining a table to a polygon layer I'm prompted to index the joining table. If I do index the table then the join fails but if I decline the join will work. I'm joining based on OID of the polygon layer. Anybody have any ideas what might cause this? I ask because once indexed the table will not join with this layer ever again.

BrianLomas · Answer

Yea, new field is a LONG INT... I'm not sure how to upload sample data.

NeilAyres · Answer

And your new field is a LONG INT, and the join item the same?

Could you give us a picture of the data or perhaps post a sample here.

Sounds very strange. Must be a reason.

BrianLomas · Answer

Now, I'm working with different data but same conditions... a SQL feature class trying to join to a shapefile. Copied the OID to a new field but named differently. And again have the same problem, once the fields are indexed zero records match. Before indexing every single one match.