Linked table inconsistent automatic linking

I have a big table (Main Table) with lots of linked records to various other tables, lookups etc. The Primary field of Main Table is Calculated.

I made a new Table, added a secondary field, and tried to link it automatically by pasting in the 100 primary fields from Main Table. But only some records will link up, w lots of fields staying blank. Exact same result when I paste in as single line text, and then convert it to a linked field.

I CAN however, link each field manually to the ones that wouldn’t automatically link. I tried looking for certain circumstances in the Main Table that were unique to those that wont link up automatically, and cannot find any trends.

I have the highest permissions, and fields are not locked that I know of. Maybe some sub-field is locked that is causing the issue?

A little unnerving because I am going to rely on some big linking operations to get each of my annual work cycle’s started. Thanks!!

tempsnip

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.